recordcount 1

[haitianfella]

Good afternoon i'm trying to get a count of all records that exist in a table regardless of the found set. I tried using the get(total recordcount) i dont know if I typed that right. But for some reason it shows the total # of records at first until I do a find then it adjust to the total of # found records. I'm trying to re-create what is seen on the status area. That shows the reord being browsed, found set, and the sort state. I've been successful with all except the total record count. Please help.

 

[JeanW]

If you are on FM8, use the function
Get(TotalRecordCount) for all the records in the table.
Make sure your calc is unstored.

To have a textfield showing all the records in the given foundset in relation to the total records in the table, use an unstored calc along these lines:

"Record " & Get ( RecordNumber ) & " of " & Get ( FoundCount ) & " Found... " & Get ( TotalRecordCount ) & " Record" &
Case(
Get ( TotalRecordCount ) > 1;"s"
) &
" Total."

Put this field as a mergefield on your layout.

 

[haitianfella]

Thanks greatly appriciated