I have some code that looks like this:
SELECT bank ,settdate, SUM(amount) AS amount, COUNT(*) AS Items ;
FROM ncredit2 ;
GROUP BY bank ;
INTO TABLE nCredit_report
For some reason SUM(amount) comes out to the right number but COUNT(*) give me the wrong number.
There should be 24 records in the table. Count gives me only 22. Is it because two of the records amount field is equal to zero (0.00)?
Thanks in advance for your help.
Randall
Thanks in advance for your help! :-)
Randall L. Johnson