I am designing a database to capture information that will be classified into
two separate categories. I would like to autonumber each record by category.
Is that possible? For example, I will likely have 2000 total records with
200 of those records in Category A and 1800 of the records in Category B.
The information will come to the data entry group in a random format. I
would like to prevent separating the information into the two categories
manually or need to enter them in two separate forms dependent on the
category.


Can I have MS Access autonumber them like this?:

A001 to A200 (for Category A) and then B001 to B1800 (for Category B) on the
same data entry form?

If so, how would I go about doing that? Any assistance will certainly be
appreciated!!

Sharon