Record Numbers?

[Zcast]

Ok, this elusive calculation seems to be hiding from me! I would like to show on my layout:

"1 of 15 out of 100 records" for the end user during a find request. Whenever I use

Get (FoundCount)

, even in find mode, it shows total number of records, not just the found set. What am I doing wrong?

[LaRetta]

Get ( RecordNumber ) & " of " & Get ( FoundCount ) & " out of " & Get (TotalRecordCount ) & " record" & Case ( Get ( TotalRecordCount ) > 1 ; "s" & "." )

And be sure to make the calculation text and unstored.

But calculations will never show in find mode.

UPDATE: If you really need this to display while in find mode, you will need to write this calculation to a global field for display ([color:green]right before entering find mode.) And then every time someone performs a find, it will need to be scripted so you can update this field again. I've never had Users require such a display but that doesn't mean yours won't.

UPDATE: Incorrect - you can set the global value while in find mode and I knew it too - I just made a mistake.

Edited January 12, 2010 by Guest
Added update

[Zcast]

Thanks LaRetta,

That is exactly the calculation that I had scripted except for this:

"And be sure to make the calculation text and unstored."

I forgot to change the storage options, that's why it wasn't working. Now it works fine.

Just needed a fresh reminder. Thanks again.