How Many FileMaker Records Found Are Showing?

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

A READER ASKS
I am attempting to get the database to show what record out of how many records found it is showing. Is there a trick to this?

-------
DWAYNE RESPONDS
There are a number of ways to achieve this and most involve some use of the Get family of functions. Here is the calculation that I typically use and you should be able to plug it right into your tables.

Get(RecordNumber) & " of " & Get(FoundCount) &"¶" &
Case(
Get(FoundCount) = Get(TotalRecordCount); "Viewing All Records";
"Viewing Subset Of " & Get(TotalRecordCount))
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.