Manually advance unique numbers in Access?

[Guest]

Need procedure / function to manually advance customer numbers in Access when
user adds new record. Procedure would have to find highest existing number,
than add 1, then return new number to field in DB. (Customer number field
type is text, though all data consists of numbers, no letters).

 

[Stefan Hoffmann]

hi Jimmy,

Need procedure / function to manually advance customer numbers in Access when
user adds new record. Procedure would have to find highest existing number,
than add 1, then return new number to field in DB. (Customer number field
type is text, though all data consists of numbers, no letters).

Use

Nz(DMax("Field", "Table"), 0) + 1

This function is not multi-user aware. So a unique index on your field
is required.

Change your field type to Number(Long Integer). If leading zeros are
needed then use an appropriate display format.

mfG
--> stefan <--