How can i combine the below query

[Yewee]

Hi All,

I have a query named "QueryPriorityStaticsByNoOfDay" and a Form named FormDateRange. Inside the Form, there is a Frame with 3 options. Option 19, option 21 and option 23.
The value for Option 19 = 1, Option 21 = 2, Option 23 = 3
When user select option 19, it should run query with NofoDay<=1, Option 21 should run with NoofDay =2 or 3 and Option 23 = more than 3 days.


Field name :



Option 19:

Select * from QueryPriorityStaticsByNoOfDay
Where NoOfday<=1
Group by Priority

Option 21:

Select * from QueryPriorityStaticsByNoOfDay
Where NoOfday= 2 or 3
Group by Priority

Option 23:

Select * from QueryPriorityStaticsByNoOfDay
Where NoOfday>=3
Group by Priority


Anyone can give idea how to do it?

Thanks.

[CJ_London]

something like

Select * from QueryPriorityStaticsByNoOfDay
 WHERE (forms!myform!myFrame=1 And [NoOfday]<=1) OR (forms!myform!myFrame=2 And [NoOfday] between 2 and 3) OR (forms!myform!myFrame=3 And [NoOfday]>=3)
Group by Priority

[Yewee]

Hi hi,

Thanks.
Can I check, I have the Form that let the user generate the report according to their selection.
For example, they will select either 'less than a day, '2 to 3 days' and 'more than 3 days'.
Once they select, the report will only generate according to that selection.

[CJ_London]

really depends on how you are running the report - you could put the where part of the query as a parameter to docmd.openreport for example - in which case you would build a string to suit based on the value of your frame.

Please don't ask a question and then move the goalposts, will it work here? will it work there? Try it and see