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

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, 201015 yr by Guest

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.

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, 201015 yr by Guest

Thanks!