Expression Builder Help!

[Karma31251]

IIf(IsEmpty(DLookUp("[Doctor Name (MD)]","tblQueryData","[PKey]='1'")),([tblMasterReferrals].[Doctor Name (MD)]) Like "*",DLookUp("[Doctor Name (MD)]","tblQueryData","[PKey]='1'")) Or Is Not Null I have this strip of code in the Expression Builder for the criteria row of a column in an Access Database Query. My objective for this is to have this code filter the records by an entry in the first row of a table, in a column with a matching name. Also, if there is no entery for that column in the table then show all records, or no filter in that column. I have six six different columns in one query i would like to do this to. I have found that if i have a criteria entry in the the table for the query and i change that column's Expression Builder Code to say Or Is Null it works, it filters the query on that table entry. But if i take that entry out of the table, it will return nothing unless I change the Expression Builder Code to say Or Is Not Null, I want the query to return unfiltered records for that column if there is no entry in the table. Can anyone tell me how i can mess these two to make a fuctional query?? Lost!