I have a calculation field to return the number of records in the current found set. It is simply:

c_FoundCount = Get ( FoundCount )

But the returned number is the total records, not the number of records in the current found set.

Any suggestions?

Thanks!

Make sure that the calculation is unstored.

You can locate the "unstored" option by:

- Entering Define Database

- Clicking once on the calculation field

- Clicking the Options... button

- Clicking Storage Options...

Check the box to "do not store calculation results -- recalculate when needed". This will make the calculation update each time the screen refreshes (e.g. mode change, record change, etc.). This is a good option to know about when you have a calculation that does not reference a field. Stored calculations don't update when there is no field reference that can be modified to trigger the result.

That's interesting ... and it worked ... thank you