"Sharon_wv" wrote in message
...
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?
No. Only one autonumber field per table, although, you can create your owb
autoincrement field.
Also, have a look at:
http://www.datastrat.com/Download/AlphaNumeric2K.zip
for some ideas.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley
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