Multiple criteria through a form

  • Thread starter Thread starter Shiner452
  • Start date Start date
S

Shiner452

I have a query with 15+ fields and I am making 3 different reports tha
people can look up certain records based on criteria that they specif
in a form. Here is an example of my problem. I have fldPotSiz
fldPotWeek. Both fields ask to specify criteria through a form
However, if I want to look up plants by fldPotSize and dont care abou
fldPotWeek (I want all Pot Weeks listed) I am unable to do so. Arent
supposed to say 'If Null' or something? Does this make sense? Any hel
would be appreciated...you can email me at (e-mail address removed).

Thank
 
I had help in another forum and got this one figured out. For anyon
who may have the same question as me here is the answer.

Criteria should go as shown below.

WHERE ((fldYourField = Forms!frmFormName!txtControlName) o
(Forms!frmFormName!txtControlName is Null))
AND ((fldYourField = Forms!frmFormName!txtControlName) o
(Forms!frmFormName!txtControlName is Null))
AND ((fldYourField = Forms!frmFormName!txtControlName) o
(Forms!frmFormName!txtControlName is Null))

Just substitute with your field names, form names, and control names
 
I had help in another forum and got this one figured out. For anyon
who may have the same question as me here is the answer.

Criteria should go as shown below.

WHERE ((fldYourField = Forms!frmFormName!txtControlName) o
(Forms!frmFormName!txtControlName is Null))
AND ((fldYourField = Forms!frmFormName!txtControlName) o
(Forms!frmFormName!txtControlName is Null))
AND ((fldYourField = Forms!frmFormName!txtControlName) o
(Forms!frmFormName!txtControlName is Null))

Just substitute with your field names, form names, and control names
 
Back
Top