Multiple criteria from a form

  • Thread starter Thread starter MB at Mirror
  • Start date Start date
M

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
 
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
 
Back
Top