Liz
I've uploaded the 2 images. Let's do some debugging.
1. create a new query from scratch.
2. Open it in SQL view and see if it matches the original query
3. check to see if you can get the filter to work in the new query.
4. run a compact on the database just in case it's a busted index or something.
Post the SQL just in case it might help us, but it could be the query is broken.
Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
Pros, I have a query that has a single parameter input for the criteria.
When I run it with the response to [Enter program code:] of "EKB", I can click on the little arrow down button and it has the little filter boxes to check and uncheck. If I answer "EKA", there are no little filter boxes, only "filter by."
Would anyone know why? Is there a limit to how many filter selections there could be?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (17) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar