Increment Transaction NO.

Originally Posted by willakawill

Hi. this is from access help:
Create a field that automatically generates numbers
Open a table in Design view.


To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.
To add the field to the end of the table, click in the first blank row.

In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.


In the Data Type column, click the arrow and select AutoNumber.


To create an incrementing AutoNumber, leave the property settings in the bottom part of the window as they are (the FieldSize property is set to Long Integer and the NewValues property is set to Increment by default).
To create a random AutoNumber, in the bottom part of the window on the General tab, set the NewValues property to Random. For more information on the types of AutoNumber fields you can create, including fields for database replication, click .

Set the other field properties, if desired.

Originally Posted by hexagram

Hey dude it helps a lot, but what if i want a formatted increment field like for example the default variable is 1 - i want it to be formatted as PC00001 (increment) and so on..?how can i do that?

Originally Posted by hexagram

Hey dude it helps a lot, but what if i want a formatted increment field like for example the default variable is 1 - i want it to be formatted as PC00001 (increment) and so on..?how can i do that?