>I do something like this:
>
>
>m.dStartDate={10/01/2000}
>m.dEndDate={10/31/2000}
>
>SELECT prenotes.bankname, prenotes.portfolio, ;
>SUM(IIF(!isnull(mid),1,0)) AS foundit, ;
>SUM(IIF(isnull(mid),1,0)) AS notfound, ;
> COUNT(prenotes.mid) AS tot_prnote ;
> FROM prenotes ;
> WHERE BETWEEN(prenotes.settdate, m.dStartDate, m.dEndDate) ;
> GROUP BY prenotes.bankname ;
> INTO CURSOR mis_prenotes
>
>
>I get a record with bankname,foundit,notfound,tot_prnote.
>
>If there are more than one bank I get a record for each bank. If a bank is missing, I get nothing. I want to get a record for all the banks that are in the table regardless of there being a numbers for it or not. For example, one record would have bank A with numbers in the fileds and Bank B would have all zeroes in it. Is this possible?
>
>Thank you in advance for your help! :-)
>randall
Randall,
In my last reply to you in inner select you don't need pr2. Sorry, my bad...
If it's not broken, fix it until it is.
My Blog