Report Filter By Form 3 options

[safam]

i have a form to generate report with 3 filters,
1.sales_person,
2.Client_Name,
3.Product_ID
these are combo selection and the report is working fine with these 3 filters. filtering by a query. all 3 feilds on the same table.
what i am unable to do is make these filters as option to select with a check box. like if i dont want the third filter product but to generate report with the other two filters sales_person and client_name.
any help would be greatly appreciated.
if any one can upload a sample that would be of great help.

edt: uploading my DB
Form report_generator on medical_request_query and table medical_requeset

 

[JHB]

...
if any one can upload a sample that would be of great help.

I think it is easier if you upload your database with some sample data, (zip it because you haven't post 10 post yet), + info which form/ report to use.

 

[GinaWhipp]

Hmm, have a look at...
http://allenbrowne.com/ser-62.html

This will allow you to filer on any combination of all three or tow or one or none to get all the records. It just needs a little modification to open the report instead of showing on the Form.

 

[JHB]

Try it now, (database attached), checkboxes removed from the form then they are not necessary.

 

[safam]

Try it now, (database attached), checkboxes removed from the form then they are not necessary.

Thanks a lot for the help.
working perfect just as I wanted it to.
can you just update me what was it that I was doing wrong.:banghead:

 

[JHB]

You're welcome.
Try to compare the Where part of the query, (before and after I change it).

 

[safam]

can any oone please give me an expression, what i am trying to achieve is:
KPI=[DeliveryDate]-[SubDate]

if [DeliveryDate]IS NULL, Date()-[SubDate] OR [DeliveryDate]-[SubDate]