Try removing the parenthesis and changing the OR to an AND. The OR may be killing your statement because you are using it between two "Not Equal to" statements. ~Chad On Tue, Feb 26, 2013 at 5:28 PM, Christian, Jessie < [log in to unmask]> wrote: > I am trying to perform an advanced query to find all photographs in our > collection. The following query indicates the three departments I don’t > want to include as well as the two object number strings I don’t want > included. However, even when I play with AND/OR operators and parenthesis, > I still get the error: *Incorrect syntax near the keyword ‘ORDER’*. Any > ideas? **** > > ** ** > > Thanks!**** > > jessie**** > > ** ** > > [image: chrisjones.png]**** > To unsubscribe, send an email to [log in to unmask] with the > following commands in the body of the email: > > signoff TMSUSERS > > // eoj > > You will receive a confirmation that your subscription has been removed. > To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.