Connor Columbus
Last Activity: Jan 13 '11, 05:22 PM
Joined: Jan 13 '11
Location:
-
Because its in a form would I double click on the text box and set the default value as this? & do you know how to make the ORD at the beginning? -
How to generate a unique Order Number starting with ORD?
The Order Number must be like this:
ORD0000
Thats "ORD" at the beginning followed by 4 numbers, I need to find the max existing Order Number and add 1 to this calculation as well.
So basically I need to know how to make a form automatically generate a new order number starting with ORD but I have to find the max and add 1 on to this to make it unique. Any ideas? -
I understand that this would work yes, but in my exam I am given data sets which start from a high number, so if I did autonumber they would reset to 1, 2, 3 and so on when I really need to find the max that they have given me and then I need to add 1 on so that its unique if you understand.
Thanks.Leave a comment:
-
How to generate a unique customer ID?
I'm trying to create syntax that will allow me to find the max customer ID from the customer table and then add 1 onto it so that it is completely unique. I would like this to be generated automatically into my add customer form, any ideas?
No activity results to display
Leave a comment: