OK. Now I understand. I think I can figure out what I need to do now that I understand what Access is doing. First I'll try what you've written above and then I'll try making sure the records are always sorted in the same way and add a field to number them in that order. It will be interesting...
Thanks, Duane!
That's interesting. When I enter a record into a data entry form, there is what appears to be a record number at the bottom of the form. I can navigate to a specific record using its number by entering that number in this field; I can also move sequentially through the records or...
I need to retrieve record numbers for a report based on a query. The record numbers are created by Access, not by me. How can they be retrieved?
I'm working in Access 2003 with a 2000 file format.
Thanks.
I need to include each Access record's record number (which is assigned by Access, not by me) in a report which is generated off of a query.
How can I extract the record number for each record?
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.