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.

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


"bettina" <(E-Mail Removed)> wrote in message
news:9259CFAC-FC93-4434-AA7E-(E-Mail Removed)...
>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.