>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

The value of field shouldn't affect a COUNT(*)
There are probably 2 deleted records. In which case RECCOUNT() would be 24 (likewise the message in the status bar), but COUNT(*) would return 22.