Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page