Autonumber in MS Access...

[DoesSpeedTurnUon]

Does anyone know how to change it from like "+1" to something else? I want the auto number to auto it with a client code or ID, like...

WD10001
WD10002
WD10003
WD10004

Instead of:
1
2
3
4
5

anyone know?

[Stang2be]

See if this does the trick for ya

http://www.databasedev.co.uk/add_prefix.html

[DoesSpeedTurnUon]

[QUOTE=Stang2be]See if this does the trick for ya

http://www.databasedev.co.uk/add_prefix.html[/QUOTE]


EXCELLANT!!! but i think i might be going a differnt way now, with a relationship to another table... not sure yet. but its getting deep!