AutoNumber in a query

[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

 

[Sakuraki]

Anyone can help

 

[Guest]

Check out Q325236 and Q12883 in the KB for an idea and adapt to your requirements