Report Filter Web Database

[Dano5]

I am not sure if i am putting this question in the right area. Please move if not in the correct area.



I have a web database that I am trying to create a search feature for just 2 of the fields. The search is for a certain date and also a shop are the 2 fields I would like to have the search run for.

Once the search has been run I would like to generate it into a report.

I have already created the report/form and the query. I am not sure where I need to go from here. I have created the form with the date and also a combo box for the list of the shops and then a button that says search that will go to the report. I just need it to show all the particular items that show the date and or shop. If you leave them both blank it will run a report and show everything. Then if you just put a date in it will run a report with just that date or the same with the shop.

I appreciate all the help i can get.

[pbaldy]

As answered elsewhere, one way:

http://access.mvps.org/access/queries/qry0001.htm