format currency for export

J

jjacob

I am running a query to export data for file upload. I can't seem to get the
currency in the format I want.

I am using this

Contribution: Format(zqryKpfRegSum!SumOfdecEmployeeAmt,"00000000.00")

so if I have $4587.79 it returns 00004587.79 but what I want is 0000458779.

I've tried removing the decimal, but then I only get the whole dollar amount.

help?
 
D

Duane Hookom

It looks like you want to multiply by 100 and then format the results:
Contribution: Format(zqryKpfRegSum!SumOfdecEmployeeAmt * 100,"0000000000")
 
Top