Simple question

[viralbhatt]

Displaying empty fields


I have tables with empty field called FullName. How can I display list of all empty field and “No carer”. Sample database is shown below.


familyid fullname joineddate
80 Sambi, bal 28/02/2003
81 03/10/2002
82 Cutler, Wate 15/09/2002
83 No Carer 5/09/2002
84 15/09/2002


I need empty full name and no carers ( 81, 83, 84). I have tried putting “ “ or “ no carer” but it only displays fields with “no carer”.

Viral

 

[ThreeCrow]

Try "IsNull" in your query criteria, this will show those that are emty

 

[viralbhatt]

No Luck

Sorry Still no luck,

It's coming with only one field and I have more then 30 fields on my database.

Any other way I can do it ?


Viral

 

[viralbhatt]

Thank you

thank you for your advise Pat Hartman. it's working now. actually it's not my database. Company I work for has already set up this database.

Viral