Getting Record Numbers for a Report in MS Access 1

[JohnH9]

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.

 

[dhookom]

There are no "record numbers" in Access. Records are like marbles in a bag. There is no order unless you identify the order in a query or SQL statement.

Do you want to simply number the records in a report? If so, add a text box:
Control Source: =1
Running Sum: Over All

Duane
Hook'D on Access
MS Access MVP

 

[JohnH9]

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 even jump to the first or last record using the left and right arrows that appear next to the number. It's this number that I need access to.

What I need to do is show this number for each record included in the report. Is that possible? If so, how?

Thanks, again.

 

[dhookom]

Try right-click in a field value and select to sort your records by that field. If this isn't your normal sort for the form, a different record will now be number 1.

The numbers that are displayed are not "linked" to any specific record. They just display the relative position when the records are sorted in a particular order.

Duane
Hook'D on Access
MS Access MVP

 

[JohnH9]

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 to compare the outcomes.

If these ideas don't work, I'll be back for more help, but from what you've said, I suspect they will.

I sure appreciate what you've told me. This is great.

Thanks again.