auto assign a sequnce number in a query in MS access

[julianahonorio]

Not sure where to post this.

empid SeqNbr
22222 1
22222 2
33333 1
33333 2
33333 3
55555 1

The query name is PD_COMM.

The main fields are:
EMPLID
EARN_CD
EARN_AMT
EARN_BEGIN_DT
EARN_END_DT

I have a query which has empids. I need to add a sequence number that restarts numbering for each empid. See example of the goal above.

Please help....

 

[NigelShaw]

hi

That's not very helpful. It maybe straightforward to you as you built it but to rest of us? You need to offer more info to get a response or even a sample db and good description

Ns

 

[julianahonorio]

Basically this is the bonus file that needs to be uploaded into People Soft and People Soft is requiring a sequence for each instance in the bonus file. For example we can have an EMPLID with different Earn_Cd and we need a sequence counter for each instance. I hope I'm making sense. It sounds right in my head when I explain it but not sure if it is coming out right

 

[julianahonorio]

Any ideas?
Thanks

 

[The_Doc_Man]

PeopleSoft? Yecch...

OK, in this forum you can search for "Custom Autonumber" and "Restart Autonumber" topics, some threads of which will address this issue.