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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TO along73 in reply to your posting...

Status
Not open for further replies.

lab509

MIS
Sep 4, 2003
5
0
0
US
What function in the formula field do I need to use? Any ideas? I was thinking ToText or ToWords, but I'm not sure how to use them.
Thanks.

(regarding your reply: Create a formula field that would check for a null and replace whatever text you want to display and use that formula field in your grouping instead.)
 
I may have addressed this in another post.

Create a formula containing something like:

if isnull({table.field}) then
"Empty"
else
{table.field}

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top