Incrementing numbers that are in a field with letters

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

Guest

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,
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incrementing characters 12
text and increment numbers 2
Data Entry Form and Auto Number ID 2
Simple Ref number for a form 2
Numeric increment 4
Increment "text" not number 2
Field number format 2
Incremental numbering added to 2 different forms 13

Back
Top