Query Conditional Autonumber

[mswhiteside]

Hello All,

I have a query that i need to have ID's that start over on certain records in the Table like below

Field 1---Conditional AutoNumber
IRM-------------1
1-----------------2
1-----------------3
2-----------------4
2-----------------5
IRM-------------1
1-----------------2
1-----------------3
2-----------------4
etc

i'm having some trouble getting the query to do the auto number though. anybody have any ideas?

[Rabbit]

If that's how your table data truly looks like, you won't be able to do it through a query. You'll have to do it through VBA code.