1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Query result not correct in Access but correct in Excel

Discussion in 'MS Access' started by Onesimus, Jun 22, 2011.

  1. Onesimus

    Onesimus New Member

    Joined:
    Jun 22, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi All

    I am an Access newbie. I am running Access 2003, using linked tables from another database called MAILman ( a database used by not-for-profit organisations in Australia). When I run a query in Access e.g. APPEAL = "XMAS2010" And DONORTYPE = "Donor Current", the results that appear after I press the Run Query button are not correct (e.g. a donor type other other than "Donor Current and/or an appeal other than XMAS2010 will appear in the results) ... but when I export the results as an Excel spreadsheet, the search results are correct. It seems I am doing something wrong ... but what?

    Onesimus
     

Share This Page