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
    Why Are There Different Versions Of Bhai Nand Lal's Rehitnama? Please Help Clarify Questions and Answers Mar 7, 2017
    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

  3. OP
    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.
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page