gibbonuk Posted November 22, 2011 Share Posted November 22, 2011 Hi i have a query that changes depending on the users selection for "narrowing" down the results. So i achived this by for each selected wanted i added a "and" opertator to the query. but for one field i want it to be And & or. But what i found is happening is its checking the or with all the ands, not just the field i want it to do. How can have multiple ands but for just one of them i want it to have a or. This all sounded very confusing to write, hope you understand. Thanks Andy Quote Link to comment Share on other sites More sharing options...
trq Posted November 22, 2011 Share Posted November 22, 2011 Use () to group your expressions. Quote Link to comment Share on other sites More sharing options...
gibbonuk Posted November 22, 2011 Author Share Posted November 22, 2011 Thanks! reading back..I cant belive the you understand my question nevermind the fast response. Works a treat. Andy Quote Link to comment Share on other sites More sharing options...
trq Posted November 22, 2011 Share Posted November 22, 2011 reading back..I cant believe the you understand my question You get used to it after a while. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.