Default Value

A

Amy Johnson

HI,

I have a query that links a table and another query. Some
of the fields of the records are blank in the query. When
I make a report out of the query the fields that are
blank are also blank on the report as well. Is there
anything I can do to the report or the query to have a
default value if no data is present?

Thanks
 
M

Marshall Barton

Amy said:
I have a query that links a table and another query. Some
of the fields of the records are blank in the query. When
I make a report out of the query the fields that are
blank are also blank on the report as well. Is there
anything I can do to the report or the query to have a
default value if no data is present?
Click to expand...


set the text box's control source to an expression like:

=Nz(fieldname, yourdefaultvalue)

just make sure that the text box is named something other
than the fieldname. If it is, change it to something like
txtfieldname.
 
Top