Query design grid splits out "or" criteria SMA007 29.09.2006 17:08:01 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

Re: Query design grid splits out "or" criteria "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 29.09.2006 17:22:21 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "SMA007" <SMA007[ at ]discussions.microsoft.com> wrote in message news:16AF397C-3022-44C0-BE31-838F9D5C4D8C[ at ]microsoft.com... [Quoted Text] >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 >

RE: Query design grid splits out "or" criteria Klatuu 29.09.2006 17:33:01 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. "SMA007" wrote: [Quoted Text] > 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 >