Change Null Value to Text

[Jon M.]

Hey everybody, here's my situation. I have a query that shows Field1 from a
table that may contain a null value. If that value is null I would like to
automatically display "text" in Field1. I'd like to not have to actually
update the data on my table, just have "text" show in the query results or
even in just a report. Is that possible? I tried making an if statement
where if Field1 = null, then "Text" but obviously that didn't work and I'm
not sure where to go from here. If its not possible to not affect my data
from the table I could use some help how to change my null to text, I also
tried using the Nz formula but I think I am missing a crucial step or comma
or something. As always any advice is greatly appreciated. Thanks.

 

[Jon M.]

Please disregard this entry, I found a previous post which solved my problem.
Thank you all.