Seuquentially number portion of records
Seuquentially number portion of records
(OP)
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?
RE: Seuquentially number portion of records
Which SQL code ?
sequentially number the records
So, you want a ranking query ?
What are the rules ?
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Seuquentially number portion of records
What are the rules ?
The query I'm running is for all records that have "poster" in another field; the PosterNumber field is empty. Once I have run this query I need to sequentially number the records in this query.
RE: Seuquentially number portion of records