Fields containing null values...

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

Guest

How do I omit fields containing null values from a report? I believe there
should be an expression but can't seem to find it. I'm trying to run a
report that lists several addresses. The street addresses consist of 2
fields (Address 01 and Address 02). Where Address 02 does not contain any
information, it currently inserts a blank field. I'd like the blank field
omitted on the final report so that it would go from Address 01 to City,
State etc.
 
Set the control to Can Shrink: Yes. This won't work if you have controls to
the left or right of the text box.
 
Use conditional concatenation in the query underlying the report -

SELECT ... , Address01 & " " & IIf(Not IsNull(Address02), Address02 & " ") &
City AS strAddress, ... FROM tblMyTableOfAddresses

Then you just use strAddress in a text box in your report.

Cheers ...
 
Back
Top