I have a field called PosterNumber in Access. I build a query that contains the PosterNumber field. I need to sequentially number the records in that query starting at 1 (not all of the records are in this query). I used to be able to number the first 3 records in this query and then Access completed the sequential numbering for me—it doesn’t do that now. Is there a quick way to do this now?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.