I am using an MS Access query with filtered with criteria from a combo box. I have a field call candidate in my table of 100 rows but not all of the fields have a candidate. 60 records have a candidate name and 40 records are blank. In my combo box (cbocandidateFilter) I default the value to "*" and would like the query to bring back all records (100 records)regardless of whether there is a value or not. The problem is that it will bring back ALL records that are NOT empty (60 records). This is what I have in the criteria: I use the NZ thinking it will allow nulls to flow through also but it does not. Any suggestions?
Like (Nz([Forms]![frmHCMBP_ApprovalScreen]![cboCandidateFilter] & "*"))