Fields/text that shows found and total records

[bens]

Hi

How can i make a Field/text in a layout that always shows the number of found and total records. depending on the search the user are doing ?

[Lee Smith]

Get(RecordNumber) & " of " & Get(FoundCount)

Be sure to Unstore the calculation (it's and option for the field in Define Fields).

HTH

Lee

[CobaltSky]

Hi

How can i make a Field/text in a layout that always shows the number of found and total records. depending on the search the user are doing ?

Hi bens,

An unstored calculation field (with result type set to text) will enable you to do this. The formula will be along the lines of:

"Viewing " & Get(FoundCount) & " records of " & Get(TotalRecordCount) & " total."

You can then place the calc field onto the layout as a conventional field box or as merge text (via the Insert>MergeField... command). :wink2: