Multiple criteria from a form

[MB at Mirror]

Help! I've done this before but can;t seem to recall how...

I have a form for selecting criteria for a report that has 3 fields with 5-7
checkboxes for each that need to be set. How do I make this work in the query
so that I get the records for what is specified, whether one box or more?

Ex: Day of the week (ck box for days needed) can be 1 day or all
Week of month (ck box for each of 1-5) can be 1 week or all
Sales # (ck box for each of 1-7) can be 1 or all

 

[perry]

I think you'll have to detail some more than what is listed in yr initial
msg.
Can't you compose the query?
Do you have difficulties realising the "all" option in the query?
Do you have difficulties having the controls (the checkboxes )to respond
correctly?

Can't see what yr problem is.
Kindly elaborate.
Krgrds,
Perry