468,168 Members | 1,716 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,168 developers. It's quick & easy.

Advanced filter... Load from Query not working...Help! * Repost *

I am running Access 2007. I have a report that I want to filter. I
can go into Advanced...Advanced Filter/Sort... and setup a filter that
works fine on the report when I apply it. When in this filter/query
creation area, I can right click and Save Query. I have saved a query
fine. However, now when I open the report back up (after closing
Access or the report) and go back to Advanced...Advanced Filter/Sort..
right click and 'Load from Query', there is nothing listed in the
selection box to choose from. The query is still showing in the Query
list on the side of the screen, but I can't open it for filtering. The
query will run fine if I double click on it, but I don't want the
query to run this way, it needs to be the source of the filter. I've
tried dragging and dropping the query onto the open query form, to the
report, etc... but to no avail. Is there a bug in Access, or am I
doing something wrong? BTW, I have installed all Office Updates as
well.

Thanks in advance!

Aug 9 '07 #1
0 1889

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Seth Delaney | last post: by
16 posts views Thread by Nhmiller | last post: by
reply views Thread by Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post: by
2 posts views Thread by chiinook | last post: by
1 post views Thread by gcdp | last post: by
reply views Thread by kamranasdasdas | last post: by
reply views Thread by gcreed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.