How to count # of records?

I think you just want to use Record.COUNT for getting the number of records for a grouping. After the filtering is set, Record.COUNT will give you a total.

Are you running this in a report? If so, then COUNTing the records before each grouping loops through isn't as efficient as just using an integer value incremented through the looping through of the records, as long as you don't need that value before the processing of those records.

Cheers!

kine wrote:

You can create one Integer variable and set it to 1.

I'm not sure what you are doing here.

I tried a test to just output a list of records from Table 18, creating a basic report using the wizard. I did the setup you suggested, and the first problem I encountered was that CREATETOTALS didn't want to take an integer type variable. Next, adding the value in the GroupFooter didn't automatically update.

For this suggestion, did you mean it would be totalled automatically, or is there more setups/coding that will make this solution work?

Cheers!

Ok, I've done all that you've described so far. Now, the only way for variables to automatically increment that I've seen is to actually display them in one of the body sections. I could, of course, do that, but the original question as I read it was just to get a count. I'm not even 100% sure the original request was about a report! *wink*

Thanks for the info!