Generate next number that starts with a letter

A

AnnieJ

I have a field with despatch note numbers, each number starts with a D, e.g.
D1234,D1235,etc. I want to generate the next available number, ie Dxxxx + 1.
I have tried and failed with DMax, I know this works with only numbers but
get an error when there is a letter. Is it possible to generate next number
while ignoring the D?
Thanks
 
D

Douglas J. Steele

You need to remove the letter D from the front (then add it back on:

"D" & CLng(Mid(Nz(DMax("[NameOfField]", "[NameOfTable"), "D0"), 2)) + 1
 

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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Concatenate Date and Number field for Append Query 0
Random Number list without duplicates in a range. 1
Access Macro Repeat Expression using value of a field in table 0
Auto Generate Numbers 2
start automatic number at a given value??? 4
Add Next Number To A Field 2
Weird auto number generating requirement 5

Top