2014-06-10, 17:58 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Access 2010 select query won't filter
It seems that my select queries aren't filtering. If I change it to a make table query, the table is filtered but if I just run the query, it doesn't see my filters. They are simple filters, nothing elaborate. Like in one field all I want is "EOM" but I get everything in that field. Does anyone else have this problem and if so how can I fix it??? As a work around, I just make tables but in some cases this isn't practical.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-06-11, 06:20 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- Thanked 23 Times in 23 Posts
why don't you send a zipped database with test data only