Preceding Zero - Urgent Help Need

[Tim]

Hi guys,

I have a query to retrieve data from sales table which
has data like the following:

ID Amount
1 52.50
2 100.00
3 1000.00

I want to change the format to the following:

ID Amount
1 005250
2 010000
3 100000

Does anyone have a idea?

Any help will be appreciated.

Thanks in advance.

Tim.

 

[Duane Hookom]

Try something like
Format(Amount*100,"000000")

 

[Tim]

Duane,

Thanks.

Tim.

-----Original Message-----
Try something like
Format(Amount*100,"000000")

--
Duane Hookom
MS Access MVP





.