Re: OutputTo to Excel question

Shohoku,

Save a query that pulls the same data as the report.
In the query add an extra column that formats the Total as currency.

In this column put
TotalAmount:CCur([TotalFieldName])
Uncheck the show checkbox for the original Total column
Switch the query to data*** view and check that the total is formatted the
way you want.
Export the query instead of the report.

Jeanette Cunningham

"Shohoku79" <Shohoku79@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FAB7C555-9967-4103-9DF7-7015C95C9B42@xxxxxxxxxxxxxxxx
Hello:

I guess this question is a combination of Exporting
data/Reports/Macros....

I have used Access to write a Check Printing application. I now have a
report where the user will enter a set of date ranges and the report will
pull all the checks wrote within that date range. It will also combine the
individual transactions under each check and provide the total amount for
the
checks using Sum([Individual Amounts]) which will workout the
pluses/minuses.

The report view works good and displays the data correctly. I also allowed
the user to be able to output the report data into an Excel file. I used a
button to trigger a Macro that runs OutputTo and I chose the Report as the
object and MS Excel as the object type and let the user select the file
name.

One thing puzzles me is in the output Excel file. The total amount for
the
Check pulled is supposed to be in Currency format, and shows up that way
in
the report with $ sign and all. However, in the Excel file generated the
column that had the totals are all showing General Numbers format. I've
gone
back and looked at my reports/tables designs and this field is listed as
Currency. But for some reason, the total that appeared correctly in the
report view didn't get its data format exported into Excel.

What could I be missing?

Thanks in advance.

Shohoku79
--



.