Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

recordcount 1

Status
Not open for further replies.
haitianfella

haitianfella

IS-IT--Management
Apr 19, 2007
36
US
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.
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Zjem
  • Locked
  • Question
Recordcount doesn't update
Replies
1
Views
70
jaco8867
jaco8867

Part and Inventory Search

Sponsor

Back
Top