Showing record number on a report

  • Thread starter Thread starter Gingre
  • Start date Start date
G

Gingre

Hi all

An old version of Access (97 in fact)

How can I show the actual physical record by each entry on a report? My
allocated ID numbers have become distinct from actual record numbers so when
I am looking at a form I select the record I want and it isn't the one I
want. So I want to keep a printed report showing the actual record number by
each entry. TIA
 
I'm afraid Access does not have record numbers. Think of your tables as a
bucket of records and Jet will return them as it sees fit which can be
different every time unless you use a query and order the records in a
certain order. Do you use a PrimaryKey on your tables? If so then how about
displaying that value?
 
What I was trying to do is use the bottom window that lets you select a
given record. I'm not using queries -- just the form itself, in conjunction
with manual list which I have printed out
 
So I want to keep a printed report showing the actual record number by
each entry. TIA
Click to expand...

If you want the first record selected for the report to be 1, the second 2,
etc. - with the understanding that rerunning the report with different
criteria or a different sort order will apply these numbers to completely
different records - you can put a Textbox on the report. Set its Control
Source to 1 (just the number one), and it's Running Sum property to Over All.

John W. Vinson [MVP]
 
Back
Top