Expression or Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the query, field name is "role". How do I populate the empty fields with
a word. In the query or in the report is fine. The word to populate is
"Register".
 
In the query, field name is "role". How do I populate the empty fields with
a word. In the query or in the report is fine. The word to populate is
"Register".
Click to expand...

In the report?
Use an unbound text control.

=Nz([Role],"Register")

In the Query?
NewColumn:Nz([Role],"Register")

Then use NewColumn in the report instead of Role.

Alternatively you could use an IIF expression:
IIf(IsNull([Role]),"Register",[Role])
 
pick a [fieldname] and try creating a new field (that you'll use instead of
"role" in whatever form or report you're creating next) by typing the
following in the "Field" box: [fieldname]: IIF([role] is
null,"Register",[role])
 
I may need to clarify that not all of the fields are blank. I only want to
populate the records that have a blank for that field.

nate martinez-wayman said:
pick a [fieldname] and try creating a new field (that you'll use instead of
"role" in whatever form or report you're creating next) by typing the
following in the "Field" box: [fieldname]: IIF([role] is
null,"Register",[role])

rciolkosz said:
In the query, field name is "role". How do I populate the empty fields with
a word. In the query or in the report is fine. The word to populate is
"Register".
Click to expand...
Click to expand...
 
Back
Top