Access 2007 - Creating and Storing a Sequence Number in a Table

[Foqus]

I'm relatively new to MS Access and creating a Document Register to maintain unique identifiers for documents based on Project and Document Information.

My Table is as follows:

Project : Document Type : Sequence Number


ABC Email 1
ABC Memo 1
DEF Email 1
ABC Email 2

I want the Sequence Number to Autogenerate/AutoCalculate. It should only increment when there are previous records and the record would otherwise be a duplicate. It needs to be stored as part of the field because it cannot change once provided.

Please help!

[rpeare]

don't mistake a unique identifier for a sequence number.

Your unique identifier should not, in most cases, be subject to any data entry. An autonumber will work fine for you. A sequence number is a different requirement that you want to figure out at the time of data entry.

in your case you would like run something that used dcount to find out if there are any records with a certain project/document type combination, if there ARE you will want to find the dmax value to find out the highest sequence number you currently have, then add 1 to that value

[NTC]

for ABC,Email,2 to generate - you must have query that finds ABC,Email,Max

and then increment up Max+1

[orange]

Foqus,

Recommend you work through this tutorial before getting too involved in Access syntax etc.