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
Thanks in advance for your help! :-)
Randall L. Johnson