Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Displaying different figures when copying info from Access to Exce

Discussion in 'Information Technology' started by bettina, Jul 28, 2006.

  1. bettina

    bettina
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    Heritage Canadian art gallery displaying Sikh Maharaja Ranjit Singh’s throne History of Sikhism Nov 27, 2010
    Leisure Okay, so I am trying to sing in a different language... Business, Lifestyle & Leisure Jul 8, 2014
    How many different types of Sikhs are there? Sikh Sikhi Sikhism Jul 8, 2014
    Gurbani of a Different Flavour Intellectual Translations by SPNers Oct 29, 2013
    Leisure If you could go back in time, what would you do differently? Business, Lifestyle & Leisure Aug 25, 2013

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    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" <bettina@discussions.microsoft.com> wrote in message
    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.
     

Share This Page