Alphacircuits
asked on
Access query to provide a sequence number
How do I add a field to a query that is a numerical sequence (1,2,3...) that resets back to 1 each time an item changes
P/N Seq
1 1
1 2
1 3
2 1
2 2
3 1
P/N Seq
1 1
1 2
1 3
2 1
2 2
3 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In your original post, you were asking for
Access query
ASKER
Thanks!
ASKER