Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter BLANK fields to show only

Status
Not open for further replies.

whimsical_data

Technical User
Oct 9, 2018
1
US
How can I only my BLANK fields to show. Its a text field for letter grades.
 
Use a selection formula like this:

Isnull({table.text}) or
Trim({table.text})=“”

Replace the quotes in the above formula with your own.

-LB
 
Of course a IsNull check will only work correctly if the formula workshop is set for 'Default Values for Nulls'. Another way to check for an empty string is Len({table.text}) = 0
 
Just to clarify, I’m sure you meant to say “is NOT set for ‘default values for nulls’”. Also, the second clause that I suggested is the equivalent of using len()=0. The second clause would make the formula work regardless of the null setting.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top