Concatenation with Null values - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Concatenation with Null values

Vern Deeker

2 years ago

Place: ([ChurchName]+" , ") & ([TownName]+" , ") & ([CountyName]+" , ") & ([CountryName])
If the first expression[ChurchName] is null, how do I return the remaining string? Help is needed. Thank you

	Juan C Rivera @Reply 2 years ago
Null Math Vern this video will provide your answers. if you still have questions let me know we can work it out.

	Vern Deeker OP @Reply 2 years ago
Still have a problem when the first expression is Null. Do I use an NZ fn or an IIF fn.

	Sami Shamma @Reply 2 years ago
share your code as it is now.

Adam Schwanz @Reply

2 years ago

Null should come up fine and just be blank. It's probably because your + instead of & the comma.
Place: ChurchName & ", " & TownName & ", " & CountyName & ", " & CountryName
If church name was null, that should come up like this
, TownVille, CountyPlace, Country
To get rid of the random commas when the value is null you use IIF
Place: IIF(IsNull(ChurchName) or ChurchName="","",ChurchName & ", ") & 'IIF... etc

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View