Concatenate with Null

[Connorbop]

Hello,

I am creating a report in which I want to concatenate multiple address cells:
[AddressObject]
[Address]
[Street]
[Town]
[Postcode]

to form a single line such as:
[AddressObject], [Address], [Street], [Town], [Postcode]

However, one or more of these fields may be null depending on the record within the database thus I need a way to eliminate that field and remove the comma before it to ensure it still forms a seamless address line. I've had a look around and tried multiple ways myself but I cannot find an answer.

Could anyone help me please?

 

[RuralGuy]

[AddressObject] + ", " & [Address] + ", " & [Street] + ", " & [Town] + ", " & [Postcode]

 

[moke123]

google - Law of Propagating Nulls (LOPN)

 

[Connorbop]

[AddressObject] + ", " & [Address] + ", " & [Street] + ", " & [Town] + ", " & [Postcode]

Thanks for this however I get a returned error saying "#Type!" within the report, why's this?

 

[RuralGuy]

Are all of the fields Text fields? What is the [AddressObject]? I would drop that one.