How can i make a timer like this 001 002 003 ?

[senzor]

Hello
how can i make my teller go 001 002 003 instead of 1 2 3

example of how i want my table:
bike 001
bike 002
bike 003
bike 004
bike 005
bike 006
bike 007
car 001
car 002
car 003
car 004
car 005
car 006
car 007
car 008
car 009
car 010
boat 001
boat 001


example of how my table is:
bike 1
bike 2
bike 3
bike 4
bike 5
bike 6
bike 7
car 1
car 2
car 3
car 4
car 5
car 6
car 7
car 8
car 9
car 10
boat1
boat1

 

[Bat17]

Assuming this is two fields, if you go to the field with the number and set itd format to 000 then it will display the way you want.
If you are combining the two fields in a query then you will need to use the Format() function
MyNewField: [MyText] & Format([MyNumber],"000")

HTH

Peter

 

[senzor]

Thnx m8!
with the FORMAT function everything works out