Joining Several Fields into One

Good afternoon,

I have address fields that I want joined into one field to place in a report.
Sounds like an easy request but I have tried and no data is present when you run the report.

I have tried addressline1 & " "& addressline2

As well as addressline1 + addressline2

No data is returned in the report...

Any help would be appreciated,

Thank you-
Who is Participating?
Ido MilletConnect With a Mentor Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If one element is null, the whole expression returns null.

IF IsNull(addressline2)
Then  addressline1 & " "& addressline2
ELSE addressline1

rporter45Author Commented:
If Statement is slightly off,

It should be then addressline1 else addressline 1 & " "& addressline2

Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.