Query to show ALL

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Access 2003

I have a form with several drop downs for the user to use to "filter" for a
report.

in the criteria of the query I have done this:
Forms!frmReports.txtSite

this seems to work fine
HOWEVER
If they do not make a selection (the drop down is blank) I want the results
of the query to be for ALL choices in that drop down.

How would I do that?

thanks

dave
 
Put

Forms!frmReports.txtSite Or (Forms!frmReports.txtSite IS NULL)

as the criteria.
 
Back
Top