Show number of all records

[CarlosB]

Hey! I'm trying to show in a field how many record i have in a table. I only know how to show the current record, but not the total of them. Any idea? Thanks!

[Inky Phil]

Do you want the total number of records in the table or the number of records in your found set?

Either way one of your options is to set up a calc field with a result of number and the option checked ' do not store, calc as necessary'

If you want the number of records in your found set set the calculation to be Get(foundCount).

If you want the total number of records in the table you can set up a self relationship based on any field that will never be empty (usually but not necessarily an auto enter key field) and set you calc field to be (Count(your new relationship::your not empty field).

There may be other. easier ways but they are the ones I know of

HTH

Phil

[CarlosB]

I did as you said, but it only shows 1 =S Am i missing something? Thanks for your help :)

[CarlosB]

Never mind, I forgot i'd made a search script, everything is ok! Thanks a lot!