=Nz(DLookUp("[First Name] & ' ' & [Last Name]","Staff","[ID] = " & [Primary] & ""), "Not Assigned"))
=Nz(DLookUp("[First Name] & ' ' & [Last Name]","Staff","[Primary] = " & [ID] & ""), "Not Assigned")
"[Primary] Is Null
Not:"[Primary] = "
"[Primary] = "
which will ALWAYS result in nothing found, so default "Not Assigned".
=Nz(DLookUp("[First Name] & "" "" & [Last Name]","Staff","[ID] = " & Nz([Primary],"Not Assigned") & "'"),0 )
Open in new window
Then add the NZ():Open in new window