Access question regarding autonumbering
Hi guys, I'm a bit stumped here regarding Access. Is there a function in access that will allow you to do autonumbering in this format:
example:
Let's say my record goes, Corvette, December Corvette, January, Corvette, February then Porsche, January Porsche February. In this case I'd want an ID field that went from 1-3 for the duplicate values of Corvette, and then 1-2 for the duplicate values of Porsche
What I'm trying to do is create an autonumbering ID field
I've tried dcount and such without any luck. Any help would be appreciated.
|