Query design grid splits out "or" criteria

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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.
 
Back
Top