Query question

[mcginty]

Hi All,

I have a form with 3 drop downs, based on a query with the criteria pointing to the forms dropdowns. Each of the criterias are in different 'Or' sections so when the form is refreshed the query works. Is it possible to use the three criteria as 'and' criteria but if only two fields are populated, the query runs based on the two criteria options.

This probably makes no sense at all, but maybe somebody can help.

Rgds,
Ted

 

[allanon]

You would need a little code to check the drop down values. Create your sql statements and away you go. Pretty straight forward.