Displaying different figures when copying info from Access to Exce

#1 (**permalink**) 28-Jul-2006, 08:22 AM

I am using Access from Windows 2000. When I query the total of a table (that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11708-displaying-different-figures-when-copying-info.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11708
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.

*

#2 (**permalink**) 28-Jul-2006, 08:23 AM

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" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11708
news:9259CFAC-FC93-4434-AA7E-71CA97DB1FC5@microsoft.com...
>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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11708