4 replies
by cpangwah Accepted solution
by Former member Accepted solution
Thanks to Wayne for this formula.
SELECT Format([TableName]![DateField],"yy") &
IIf(Len([TableName]![AutoNumberField])=1,"00",IIf(Len([TableName]![AutoNumberField])=2,"0")) & [TableName]![AutoNumberField] AS NewName
FROM TableName;
This will work up to record 999 (after that you will have to alter the
formula - but quite simple)
Note that this is a text string not a number so you will need to add the
other columns to the query to be able to sort it.
Please post back if you have more problems or questions.
by cpangwah Accepted solution
by cpangwah Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending