Record Number on report

[KimTong via AccessMonster.com]

Hi,

Is anybody can help me wiht this simple question, but I've never done it. How
can I display a record number on the report?

KT

 

[Guest]

Record numbers do not exist in Access.
There is an AbsolutePosition property, but that is only applicable for the
current view of the dataset. Filtering, sorting, inserting, or deleting
records will change that number.

What is it you are wanting to do?

 

[Jeff Boyce]

Define "record number".

Access does not, so you will have to.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KimTong via AccessMonster.com]

Hi,

Thank you for the answer. I just want to know, which record we entered it
first. For example, I sort the record by date, but we have 10 records have
the same date, so I want to know which record I entered first on the day.

 

[Jeff Boyce]

If, instead of EntryDate, you stored EntryDateTime, you could sort by that
field. Where is your EntryDate coming from?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KimTong via AccessMonster.com]

Ok, I got you. So noway to display the record number in Access, right...
Thank you.

KT

If, instead of EntryDate, you stored EntryDateTime, you could sort by that
field. Where is your EntryDate coming from?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi,

[quoted text clipped - 9 lines]

 

[Jeff Boyce]

It's not that there is no way to display it, it is that one does not exist
unless YOU put it in. But if you added a RecordNumber field, you could
display that.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Ok, I got you. So noway to display the record number in Access, right...
Thank you.

KT

If, instead of EntryDate, you stored EntryDateTime, you could sort by that
field. Where is your EntryDate coming from?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi,

[quoted text clipped - 9 lines]

KT