Query result not correct in Access but correct in Excel
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?
|All times are GMT +5.5. The time now is 18:21.|