Multiple Checkboxes -> Query

jnfr

New member
Local time
Today, 08:06
Joined
Apr 11, 2008
Messages
6
I'll try to explain this as best I can.

I am working on the queries and reports section of my database. My database consists of various data grouped by Month, Week and Department, and within each Department, there is a Category and a sum of Data.

To open the reports, I want to allow the user to be able to select which Month's and Week's data to present. I have checkboxes corresponding to Months (years spans June to May, or All) and Weeks (1 to 5, or All). I have named my checkboxes like so:

Months:
cb1 - June
cb2 - July
..
cb12 - May

Weeks:
cbw1 - 1
cbw2 - 2
..
cbw5 - 5

The user is able to select from one up to all the months/weeks for which the data should be displayed.

How do I write the criteria for the query for this? Something along the lines of, get the data of this month if it is checked and within each month, show the data for the weeks specified. Is there also a criteria for All? Something like, if June, July are checked, and all weeks are checked, then show the appropriate data?

Let me know if I make any sense! Thanks for your help!
 

Users who are viewing this thread

Back
Top Bottom