Query to show record # 1

[Dedicated]

I need to generate a report listing each record#.

My query shows the AuditID# [AuditID]AutoNumber for each record create in a form,but I need to show the acutal Record number affiliated with the audit number as well. How do I extract this information or create a query that will allow me to perform this task?

Thanks,

Dedicated.

 

[bitmite]

if you are talking about the number that shows up at the buttom of the form in he navigation bar then you can't. That number is the postion to which the record is in at the current moment in time. it does not relate to the record.

for example if you change the sorting of the form or table the numbers will all be different.

I sujest you egnor those numbers and do not rely on them to find a record within a table. it will only get you into trouble.

seen it happen way to many times.


Brought to you By Nedaineum
The Portal to Geek-tum

 

[Dedicated]

Thanks so much for your advise. I thought that was the case but I wasn't certain until you confirmed it.