If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Query to show ALL
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 |
#3
|
|||
|
|||
Query to show ALL
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 |
Thread Tools | |
Display Modes | |
|
|