How to show current record #?

[ez-rider]

I browsed forums, googled web and news groups, but found no answer :

I have a layout for browsing, and I would like to have a current record number/total number shown.

Like "172nd of total 211 records" or just 172/211

How I do that?

Thank you!

.ez.

[VICH]

Link

this is a link the the filemaker website...it has a knowledge base where alot of the simple stuff and even alot of the hard stuff is already answered..this should be exactly what you're looking for...the only thing i will add is that you may have to adjust your page number calculation by dividing by 2 "= INT (((SUM (Total Count, Total Count) - 1) / 9) + 1)/2)"

...sometimes it doesn't come out right but if you play with the last operation on the end of the calc you should get it..but thats should work no problem

Edited September 13, 2005 by Guest

[ez-rider]

thank you for your effort .. but I do not need page number on report .. I need record number in browse mode ..

thank you anyway

.ez.

[VICH]

you can still make it work just change where the 9 in the example is to 1

[ez-rider]

I am afraid that I do not follow :

[VICH]

follow the example but make your total record calc look like this

= INT ((SUM (Total Count, Total Count) - 1) / 1) + 1)

and some times when i use it i have to do an extra step and its

= INT (((SUM (Total Count, Total Count) - 1) / 1) + 1) / 2

[comment]

Define a calculation field with the following calculation:

"Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) & " in total"

Change the text strings to whatever you prefer.

If you want to display the total of found records, use Get ( FoundCount ) instead or in addition to Get ( TotalRecordCount ).

Set the result of the calculation to text, and in Storage options check the "Do not store... " option.

In layout mode, place this field on the layout, preferably as a merge field.

Edited September 13, 2005 by Guest
typo

[VICH]

there are always easier ways that i don't know about...they way i have been doing it was how i did it from the start...oh well live and learn

[ez-rider]

thank you .. I think that should work .. but what do you mean by "merge field"? :

regarding FM not your post,

I do not like that you have to make a field in table just to show number of record/total records ..

.ez.

[comment]

1. See FM Help > Creating and managing layouts and reports > Adding fields to a layout > Placing merge fields on a layout.

2. You can show the record number alone by typing @@ directly onto a layout. There's no such shortcut for the total.

[ez-rider]

2. You can show the record number alone by typing @@ directly onto a layout. There's no such shortcut for the total.

Marrie me!

P.S. Merge field = << >> great thing : thanks