Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JohnH9

  1. JohnH9

    MS Access Record Number

    Thanks, Joe.
  2. JohnH9

    Getting Record Numbers for a Report in MS Access

    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...
  3. JohnH9

    Getting Record Numbers for a Report in MS Access

    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...
  4. JohnH9

    Getting Record Numbers for a Report in MS Access

    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.
  5. JohnH9

    MS Access Record Number

    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.

Part and Inventory Search

Back
Top