Built-in function for total number of records?

[faithhay]

Is there a built-in function that will return the total number of records? If so, can it be used in calculations?

Does it vary when it's used in subsummaries by giving only the total number of records for the subsummary? If so, is there a way to get the total number of records for the whole database, even when the calculation is made within a subsummary?

[stanley]

Faith:

What you're looking for is Status(CurrentRecordCount), which returns the number of records in the database, and Status(CurrentFoundCount) which returns the number in the current found set. These do not work with summary fields.

-Stanley

[stanley]

Faith:

Actually, let me clarify that. The two Status() functions I mentioned will work within summary areas, but will continue to show their correct values. Both should be set to be Unstored Calculations, in order to reflect current data.

-Stanley