Query design grid splits out "or" criteria

G

Guest

I am designing a query based on parameters entered from a form. I have
entered many parameters such as:
[Forms]![FormMainSearchPopup]![apbox] or
[Forms]![FormMainSearchPopup]![apbox] is null

The query works fine, however, After I run the query and go back to design I
now have a field in the grid called [Forms]![FormMainSearchPopup]![apbox]
with multiple criteria set to "is null" and my original criteria is now
"Forms]![FormMainSearchPopup]![apbox]", missing the "or
[Forms]![FormMainSearchPopup]![apbox]"

This makes it difficult to go back and edit the query's design.

Any one have any info on this?
Thanks in advance.
Brian
 
D

Douglas J. Steele

Unfortunately, Access has a nasty habit of rewriting SQL to suit its own
purpose. There's really nothing you can do about it, other than stick
strictly to the SQL View once you've made the query.
 
G

Guest

It may be a little kinder if you put each criteria on a separate line rather
than using Or on one line.

If that doesn't work, the as Douglas suggests, change to SQL view before you
save the query, and leave it that way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top