record count collumn

[Guest]

i want a collumn on my query that tells me the record count of that record,
like the navigation buttons of access, every time that you change record,
the small field on navigation bar tells you the record that you are at the
time.
is it possible that i have those values in a collumn of my query??

thank you

 

[Jeff Boyce]

Roy

The navigation "count" tells you a relative position, but only for THAT
view. Data is stored in "buckets", with an internal order only Access (and
Bill) knows. The order that you are asking for is dependent on the order
you impose by sorting.

If you are looking for a way to rank-order a query, check this newsgroup (or
Google.com) for previous answers on this topic (rank-order).