• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

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-
cms
0
rporter45
Asked:
rporter45
1 Solution
 
Ido MilletProfessor 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


0
 
rporter45Author Commented:
If Statement is slightly off,

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

Thank you!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now