Combine fields and skip blanks

[Angel69]

I want to combine six different memo fields into one. I found this code and it works to combine two fields so I edited to add a third and it does not do anything.

Comments: [QAComments1] & IIf(IsNull([QAComments2]),"","; " & [QAComments2])

This is my edited code to add a third field:

Comments: [QAComments1] & IIf(IsNull([QAComments2]),"","; " & [QAComments2] & IIf(IsNull([QAComments3]),"","; " & [QAComments3]))

What am I missing to add the other fields? TIA

 

[CJ_London]

looks like you have a bracket in the wrong place

Comments: [QAComments1] & IIf(IsNull([QAComments2]),"","; " & [QAComments2][COLOR=red]) [/COLOR]& IIf(IsNull([QAComments3]),"","; " & [QAComments3][COLOR=red])[/COLOR]

 

[Angel69]

I'm getting closer to getting it but now it's got the extra semicolons if the field is blank. How do I eliminate them if memo field is blank?

zzGap: [Gap1] & IIf(IsNull([Gap2]),"","; " & [Gap2]) & IIf(IsNull([Gap3]),"","; " & [Gap3] & IIf(IsNull([Gap4]),"","; " & [Gap4]) & IIf(IsNull([Gap5]),"","; " & [Gap5] & IIf(IsNull([Gap6]),"","; " & [Gap6]) & IIf(IsNull([Gap7]),"","; " & [Gap7])))

See result here:

Verification not complete; ; ; Missing demonstration or statement of due diligence method; ; Supporting email documentation not maintained for disbursement;

 

[CJ_London]

try changing

IIf(IsNull([Gap2]),"","; " & [Gap2])

to

IIf(nz([Gap2],"")="","","; " & [Gap2])