Auto Number Formatting

[AllusiveKitten]

Hi All

I have just come up with an issue that requires a formatted auto number ie QSTR001, QSTR002 etc, is it possible for this field to be directly put into the access table as an auto number?

Or do I have to Conconate it in the Report? With the QSTR & "#"

If I do have to conconate it, how do I code a single digit such as 1 to be shown as 001?

Thank again for you help
AK

[ADezii]

Hi All

I have just come up with an issue that requires a formatted auto number ie QSTR001, QSTR002 etc, is it possible for this field to be directly put into the access table as an auto number?

Or do I have to Conconate it in the Report? With the QSTR & "#"

If I do have to conconate it, how do I code a single digit such as 1 to be shown as 001?

Thank again for you help
AK

You can store the next Formatted Number in sequence directly in the Table, but it cannot be an AutoNumber. It must be stored as Text and should probably be the Primary Key. The Formula would be
[CODE=vb]"QSTR" & Format$(Val(Rig ht$(DLast("[Your_Field]", "tblYour_Table" ), 3))+1,"000")[/CODE]

[AllusiveKitten]

Thank you ADezzi
Your a great help.
AK

[ADezii]

Thank you ADezzi
Your a great help.
AK

Always glad to help AK. Please don't mind the Shortcut, it's a little easier than typing AllusiveKitten (LOL).

[AllusiveKitten]

Always glad to help AK. Please don't mind the Shortcut, it's a little easier than typing AllusiveKitten (LOL).

I understand what you mean, why do you think I only type AK.....lol, I am just as lazy.....hehe