AutoNumber in a query

  • Thread starter Thread starter Sakuraki
  • Start date Start date
S

Sakuraki

Hi all,

I would like to set the autonumber in duplicate data in sequentia
format, example shows

Item Autonumber
ABC----- 1
ABC----- 2
ABC----- 3
IJH----- 1
DJG----- 1
DJG----- 2
ILK----- 1

Can I use SQL wihout involving VB Code? If I need to use module, wha
should I do? Thanks for your feedback in advance
 
Check out Q325236 and Q12883 in the KB for an idea and adapt to your requirements
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transform/PIVOT Query 4
need to rank in a query 4
Help with DMin? 2
Running Totals in Make Table/Update Query 6
Restart record count when the value in a specific field changes 3
Query Parameter using multiple options 0
Assistance with calling UDF from a query 6
Concatenate multiple records in query 2

Back
Top