Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Query result not correct in Access but correct in Excel (http://www.go4expert.com/forums/query-result-correct-access-correct-t26118/)

Onesimus 22Jun2011 12:11

Query result not correct in Access but correct in Excel
 
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


All times are GMT +5.5. The time now is 07:41.