Incrementing numbers that are in a field with letters

S

Shinra14

Hi,

What I would like to do is have an inquiry number PL0001 and then have the
number part increment every time a new record is created. For example, the
first record is PL0001 and then the next one is PL0002. Is this possible?

Thank You,
 
K

KARL DEWEY

Set field default to "PL" and just add the digits.

Use the query below to know what the next number should be --
NextNumber:Max (Val(Right([MyField],4)))+1
This is assuming that you are using four digits.

It would have been better to add the "PL" prefix to the number in the report.
 
Top