Query based off drop down from report

[thedeadzeds]

Hi Guys,

I wonder if anyone can help? I’ve adopted a database from previous employee and I’m trying to modify one of the querys.

Basically, qry_individual runs based off the drop downs from the frm_reports. I have added 3 combo boxes on the frm_reports, Workstream, Flow Leader and FLM.

At present, if I select staff or area qry_individual runs based off these drop downs, but for the life of me I cannot adapt the query to run if I select, workstream, Flow Leader or FLM?

Can anyone help?

Many thanks

 

[JHB]

You are not adding the comboboxes into the query.

 

[JHB]

Try it now and see if it gives you what you are looking for.

 

[thedeadzeds]

Awesome, works like a treat and you have designed the query that now makes complete sense. Thanks very much