As Arvin points out, the Access Autonumber is not what you're looking for.
Based on your description, you have two fields, not one.

One field is the "category" (A or B). The other field is a sequence number
(1-1800). Don't store those two "facts" in a single field -- instead, use a
query to concantenate them as needed.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"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? 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