|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 20th, 2007, 06:30 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Record Number on report
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 -- Message posted via http://www.accessmonster.com 
|
|
#2
July 20th, 2007, 06:58 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Record Number on report
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? -- Dave Hargis, Microsoft Access MVP "KimTong via AccessMonster.com" wrote: 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 -- Message posted via http://www.accessmonster.com
|
|
#3
July 20th, 2007, 06:58 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Record Number on report
Define "record number".
Access does not, so you will have to. Regards Jeff Boyce Microsoft Office/Access MVP "KimTong via AccessMonster.com" u35279@uwe wrote in message news:7576dde818fb0@uwe... 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 -- Message posted via http://www.accessmonster.com
|
|
#4
July 20th, 2007, 07:53 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Record Number on report
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. KimTong wrote: 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 -- Message posted via http://www.accessmonster.com
|
|
#5
July 20th, 2007, 08:11 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Record Number on report
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" u35279@uwe wrote in message news:757797b5cf1a0@uwe... 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. KimTong wrote: 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 -- Message posted via http://www.accessmonster.com
|
|
#6
July 20th, 2007, 08:42 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Record Number on report
Ok, I got you. So noway to display the record number in Access, right...
Thank you. KT Jeff Boyce wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#7
July 21st, 2007, 12:41 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Record Number on report
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 "KimTong via AccessMonster.com" u35279@uwe wrote in message news:7578056a26d82@uwe... Ok, I got you. So noway to display the record number in Access, right... Thank you. KT Jeff Boyce wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
