YOu want to display any record wherer any of those fields are missing, correct?
Likely you just need a really long select statement with a tonm of ORs.
YOu will have to tweak this basedon the field types as I am guessing at them here.
isnull({table.customer#}) or
isnull({table.x-ref}) or {table.x-ref}="" or
isnull({table.first name}) or {table.first name}="" or
isnull({table.last name}) or {table.last name}="" or
isnull({table.address}) or {table.address}="" or
isnull({table.city}) or {table.city}="" or
isnull({table.state}) or {table.state}="" or
isnull({table.phone number)}