Error Msg on Export

[Dee]

When I export to Excel, an error message comes up:

decimal field's precision too small

I've tried changing the numeric fields to show 2 decimals
and then changed it to auto, but the error message keeps
coming up.

Thanks for your help,
Dee

 

[Jeff Boyce]

Dee

Is it Excel or Access that's giving the error?

What is the decimal precision of the Access data?

What is the decimal precision of the Excel cell?

 

[Dee]

I'm in access and after running my report, which comes up
fine, I go to "file" "export" and select excel
type. "Export" shows at the bottom left of the screen
showing the progress. After all of the progress squares
are done, the error message comes up.

When I go to excel, the file name is there, but the file
is blank.

There's almost 16,000 lines in the access report. I've
copied and pasted one line into Excel and it has no
problem.

I also have several other reports using the same tables
that are just as large and they export fine.

I have gone to the report design and selected "2" for the
decimal in the properties and have also selected "auto".
Neither of these worked.

The Excel file doesn't exist until the export is done.

 

[Ernie]

Change the numeric fields in your access query to
calculated fields using the format() function. This should
force the correct precision on export.