+ Reply to Thread
Results 1 to 3 of 3

Excel showing two different results from access query

  1. #1
    Registered User
    Join Date
    10-19-2015
    Location
    England
    MS-Off Ver
    Office 2013
    Posts
    2

    Unhappy Excel showing two different results from access query

    Hi guys, new member here.

    I hope I have posted this in the correct section!

    I've done a little bit of a search on the net and I can't seem to find an answer to this..

    Basically we have a query here that works just fine when run through access. When we try to link it to excel however, it shows up different data.

    The query is pretty simple, but carries across a fair amount of data (5367 lines).

    It is strange because the data is pretty much identical in both places, but on excel, some of the values (of our sales) have changed. Excel actually ends up showing that we have made less money than access says.

    This is choosing the 'link data from access' option through excel.

    However, if I right click on the query in access and choose 'export to excel' the correct values are actually displayed in excel!

    So somehow, pushing the data from access is correct, and pulling the data from excel is incorrect..

    (Excel and access both 2013 versions, latest updates)

    We really need the live link to a spreadsheet.

    If anyone has come across this issue, or has any idea what is going on, I'd be very grateful to hear back.

    Thanks

    Dan

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,249

    Re: Excel showing two different results from access query

    Lots of words ... Please provide a sample worksheet with clear information and expectations!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    10-19-2015
    Location
    England
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Excel showing two different results from access query

    Basically, query results (sum totals) differ when run on Access and Excel

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-08-2015, 08:12 PM
  2. [SOLVED] VBA to export Access Query results to Excel
    By jmzis4me in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2014, 06:34 PM
  3. [SOLVED] Can I import the results of an Access Query into Excel?
    By MrChips in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2012, 05:57 PM
  4. Pull query results from Access to Excel
    By yellephant in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-30-2007, 02:50 PM
  5. [SOLVED] VBA - query an Access table -> results in Excel
    By rirus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2006, 02:35 PM
  6. Access query results to Excel
    By piano banger in forum Excel General
    Replies: 2
    Last Post: 08-14-2006, 07:30 PM
  7. Access Query Results in Excel, On Network Drive
    By Mkren911 in forum Excel General
    Replies: 2
    Last Post: 01-20-2005, 04:28 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1