Qry To Exclude Record If All Fields On Page Is Blank Except Field "xx", "yy" And "zzz
Dear all,
Basically, i need a query to exclude all records ONLY if ALL selected fields are blank. (means if one of a field has a value, it still shows up, only all blanks will not show up).
I had a command button which opens up a new form for inputs like this:
stDocName = "frmEmployeesHIPO"
DoCmd.OpenForm stDocName, , , qryFilterBlankHipo
where what i did in the qryFilterBlankHipo is that i included all the fields in that form except 3 fields that are reused fields from 1st form (to display again the EmployeeID,name e.g.) , i built a query and added all fields except the 3, and in the Criteria, i tried Not Is Null, ="" in ALL of the fields in the same row but it does not work i wondered why.
Do i have to set filteron to true or something?
Attached is the Screenshot of the query.
Please guide me. Thanks a lot~
VanCe
Dear all,
Basically, i need a query to exclude all records ONLY if ALL selected fields are blank. (means if one of a field has a value, it still shows up, only all blanks will not show up).
I had a command button which opens up a new form for inputs like this:
stDocName = "frmEmployeesHIPO"
DoCmd.OpenForm stDocName, , , qryFilterBlankHipo
where what i did in the qryFilterBlankHipo is that i included all the fields in that form except 3 fields that are reused fields from 1st form (to display again the EmployeeID,name e.g.) , i built a query and added all fields except the 3, and in the Criteria, i tried Not Is Null, ="" in ALL of the fields in the same row but it does not work i wondered why.
Do i have to set filteron to true or something?
Attached is the Screenshot of the query.
Please guide me. Thanks a lot~
VanCe