I am trying to build a form that provides the query perameters for a report. On the parameter form, I build a combo box that selects from a list of offices and entered the following criteria in the query: [Forms]![Date Range]![Office] And <=[Forms]![Date Range]![Office].
The query returns correctly if an office is selected. However, I want the query to return all the records for all the offices if no value is selected from the combo box. How can I change the query criteria to make this happen?
Please note that I'm a rookie!
Thanks for your Help!