Null Value Formatting

[Guest]

I know I have seen this answered here before, and I have even DONE it myself,
but I forgot HOW!

I have a field that contains a numerical value, if the field is NULL that
means it was not sampled for that specific date. What I want is instead of
the field being blank I want the query to return "Not Sampled".

I thought that somewhere I need to put this: #.##,,,"Not Sampled", I just
can't remember where!

Thanks for the help!

 

[Douglas J Steele]

It's the Format property.

 

[Guest]

Thanks, I was also using commas instead of semicolons.
--
Never give up, the answer IS out there, it just takes a while to find it
sometimes!

It's the Format property.