View Single Post
Old 07-22-2013, 03:13 PM   #1
TheyCallMeBruce
Likes Cartoons
 
TheyCallMeBruce's Avatar
 
Join Date: Apr 2004
Exp:
Default 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.
TheyCallMeBruce is offline   Reply With Quote