|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 13th, 2010, 01:21 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Sequential Form Field Number Formula
I am not sure how to do the following.
We have project numbers that are made up of 3 parts "C" (representing Customer), "10" (representing last two digits of year), and then a 3 digit number starting with "000". My issues is I need a default that looks adds 1 to the last 3 digits. So if the Project number was C10000 then the default for a new project should be C10001, C10099 becomes C10100, etc. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 
|
|
#2
February 13th, 2010, 03:15 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Sequential Form Field Number Formula
On Sat, 13 Feb 2010 01:21:54 GMT, "szag via AccessMonster.com"
u2885@uwe wrote: You can use the often-discussed "DMax+1" solution. You will have no trouble finding references at groups.google.com or elsewhere. To format a number with 3 digits, use the Format function. PLEASE don't use this field as your primary key. -Tom. Microsoft Access MVP I am not sure how to do the following. We have project numbers that are made up of 3 parts "C" (representing Customer), "10" (representing last two digits of year), and then a 3 digit number starting with "000". My issues is I need a default that looks adds 1 to the last 3 digits. So if the Project number was C10000 then the default for a new project should be C10001, C10099 becomes C10100, etc.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
