Manually advance unique numbers in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
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).
Click to expand...
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 <--
 
Back
Top