Query with empty fields

[LG]

I have a table with members and pharmacies. If it is a pharmacy the L_name
field is blank. I am running a query and want to know how many pharmacies I
have without the members. If I put (" ") in the L_name field and ask for
F_name and platform etc I don't get any results. What is another way I can
pull only if there is something in the F_name field and the L_name field is
blank?
Thank you

 

[Marshall Barton]

I have a table with members and pharmacies. If it is a pharmacy the L_name
field is blank. I am running a query and want to know how many pharmacies I
have without the members. If I put (" ") in the L_name field and ask for
F_name and platform etc I don't get any results. What is another way I can
pull only if there is something in the F_name field and the L_name field is
blank?

A field in a table should never contain only a space
character. If the field in the table has its
AllowZeroLength property set to Yes, then the field might
contain either a Zero Length String (ZLS) or Null

You can use the LName criteria:
Is Null OR = ""

and the FName criteria:
Is Not Null AND <> ""

You can avoid all this "blank" confusion by setting the
field's Allow Zero Length property to No. then you would
only need to check for Null or non-Null.