Question

Locked

how to generate Autonumber with Date together in Access 2002

By cpangwah ·
I have a field call PIR No, in this field I want a Date and a autonumber appear in this field....thanks.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

This might help....

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.

Collapse -

from your formula, how to apply it??

by cpangwah In reply to This might help....

thanks for your formula, sorry i am new to access. Can u help where do i put tat formula in? can u provide step by steps...many thanks!!

Collapse -

I want to output my Access Form data into Microsoft Word with a click.

by cpangwah In reply to from your formula, how to ...

I want to output my Access Form data into Microsoft Word and auto save into C drive with a click of a Command button. Can u provide the steps...many thanks!

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums