Seuquentially number portion of records

[beth1959]

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?

 

[PHV]

I build a query that contains the PosterNumber field
Which SQL code ?

sequentially number the records
So, you want a ranking query ?
What are the rules ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[beth1959]

So, you want a ranking query ?
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.

 

[beth1959]

Oh, this is for Access 2010.