Displaying different figures when copying info from Access to Exce

[bettina]

I am using Access from Windows 2000. When I query the total of a table (that
I had just created), I get a certain figure. When I copy the table to excel,
I am $.02 less than the sum query I had previously ran. Ideally, the 2
figures should be the same, as the data used is the exact same data. The
table has settings set to currency, so there's only 2 decimal places.

 

[Jeff Boyce]

Bettina

Currency data type records four decimal places of accuracy, no matter what
you have the format set to for display purposes. I suspect a rounding
error.

One way to approach this is to create a query and explicitly convert the
results of your sum to "text" format. But if you are exporting the raw
data, and expect Excel and Access to sum/round the same way, you'll probably
have to get more explicit about your data types.

Regards

Jeff Boyce
Microsoft Office/Access MVP