Same Queries Different Dates Question.

S

Sarah

Hi

Newbee here sorry. I have written some queries, 6 in total and each one is
based on a selection of 3 date range's. So basically for each query there is
3 options for date, ALL, 30 days {between now()-30 and now()}, and User
Input {Between ["StartDate"] and ["EndDate"]} I know I could have all three
variations of all 6 queries (18 queries) and a button (18 Buttons how busy)
to each but hoped to do it a bit smarter than that. Is there an easy way
(remember I'm new to this :) to do this say using check boxes on a form so 1
button 3 checkboxes, one query with variable date options some how. Maybe
with a module I can call or using another table or query or something. If
it's to techy and you don't think I should go there please just say so, I
can handle it :)

Sarah
 
M

mscertified

Yes it can be done but no its not easy unless you know Visual Basic.
You could either build a custom query from scratch in VB. Or, you could have
different queries saved and determine which one to run based on the contents
of the checkboxes. The latter would be easier for you to do.

-Dorian
 
Top