format currency for export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It looks like you want to multiply by 100 and then format the results:
Contribution: Format(zqryKpfRegSum!SumOfdecEmployeeAmt * 100,"0000000000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMATTING RESULTS IN CALCULATED FIELD 4
Change number format 1
Format Currency field into zero filled text field 1
Currency Format in a query 1
Currency Format Lost in Union Query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Decimal Field's Precision Too Small to accept the numeric you ... 3
Format currency in a query 2

Back
Top