Query to show ALL

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.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"dave" wrote in message
...
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

Thank you sir - that fixed me up.

Dave

"Douglas J. Steele" wrote in message
...
Put

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

as the criteria.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"dave" wrote in message
...
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