Record ? of ? records in found set

[Kevin Cheesman]

Hi,

How do I show something like 'record 2 of 876 records' on my layout?

I've use a Summary field to get the number of records in the found record set, but I would like to show the user where they positioned are within the found set.

TIA

[TheTominator]

Instead of a Summary field you can use an unstored calculation field.

The calculation would be:

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

Make sure that the "do not evaluate when all fields are empty" box is unchecked so that this calculation is always evaluated.

Edited March 17, 2010 by Guest

[Kevin Cheesman]

Thanks for the reply.

Perhaps this is not what I want then as it just show all the records in the table.

I have a layout portal that filters records by sales area. Out of the 6000 odd records I have, it will show, say 800 for a particular sales area. It's from this set of records I want to show the user where they are within the record set.

A Summary field gives me the number of records in the portal.

[TheTominator]

To display info about a portal you would use Get(PortalRowNumber) to display what record the user is currently focusing on in the portal.

Edited March 17, 2010 by Guest

[Kevin Cheesman]

Thanks!