Dynamic multiple criteria in a single field

[Wulf13]

I have a query that displays all records. I need it to limit based on multiple criteria in a single field. I.E... instead of all employees from every section, I just want it to display employees from section A, C, D, F one time and next time maybe go with section B, C, D. For some reason the solution eludes my little brain.

 

[wazz]

something like this might help:
http://www.access-programmers.co.uk/forums/showthread.php?t=125837

 

[Wulf13]

Its close but that example covers a ordered range. I want it to be dynamic. Instead of a range I would like to be able to pick out just specific days in within in the range. I.E...instead of Sun thru Sat results, I'd like any combination of days such as Mon, Wed, Thur or Tues, Wed, Fri.

 

[wazz]

oic.
not sure if this is the best way for you, but, on your popup form you can add any number of text boxes or comboboxes (seven, i guess, one for each day) and then have multilple criteria in your query for your form - put each criterion on a separate line, under one column (this is like saying "OR" as you will see in the query grid):

          [u]YOUR FIELD IN GRID [/u]
Criteria: Forms!frmName!Combo0
or:       Forms!frmName!Combo2
          Forms!frmName!Combo4
          Forms!frmName!Combo6
etc.

hth.