×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

recordcount

thread295-1360543

recordcount

recordcount

(OP)
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.

RE: recordcount

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.

RE: recordcount

(OP)
Thanks greatly appriciated

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close