>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
OK, third try :) [i keep getting a validation message...]
Sounds like there's 2 deleted records. RECCOUNT() and the status bar message that shows the record count include deleted records, but if SET DELETED is ON (which it probably is), then COUNT(*) does not include deleted records.
Insanity: Doing the same thing over and over and expecting different results.