I have found several posts on this, but can not really make sense of what I am writing.
I am using a form with 8 unbound text boxes to enter criteria for a Query. I have the following SQL statement written, which works for the two fields, but I am not sure how to add the other fields.... Also, I would like for it to be "like" for each field... so not matter what is entered, it will bring up anything that falls under this criteria... Also note, I don't want to "have to" enter data in all the fields... I would like to be able to enter data in one field, a few fields, or all fields... This would be the most wonderful birthday present ever, if someone could please help!!!!
WHERE (((PFEP_RACK_AUDIT_INQ.TOP_LVL_IDENT1)=Forms!Switc hboard_PFEP!INQ_ARRANGEMENT) And ((PFEP_RACK_AUDIT_INQ.PSA)=Forms!Switchboard_PFEP! INQ_PSA) And ((PFEP_RACK_AUDIT_INQ.TOP_LVL_IDENT1)=Forms!Switch board_PFEP!INQ_ARRANGEMENT)) Or (((PFEP_RACK_AUDIT_INQ.TOP_LVL_IDENT1)=Forms!Switc hboard_PFEP!INQ_ARRANGEMENT) And ((PFEP_RACK_AUDIT_INQ.PSA)=Forms!Switchboard_PFEP! INQ_PSA) And ((IsNull(Forms!Switchboard_PFEP!INQ_ARRANGEMENT))< >False)) Or (((PFEP_RACK_AUDIT_INQ.TOP_LVL_IDENT1)=Forms!Switc hboard_PFEP!INQ_ARRANGEMENT) And ((IsNull(Forms!Switchboard_PFEP!INQ_PSA))<>False)) Or (((IsNull(Forms!Switchboard_PFEP!INQ_ARRANGEMENT)) <>False) And ((IsNull(Forms!Switchboard_PFEP!INQ_PSA))<>False)) ;