How to combine two columns into one

[JRCharlie]

Hi all
I have memo columns named column A and Column B.
I'm trying to pickup the notes from column A and column B into column C seperated by "," .
So far my query seams to work accept it does not check if column B is Null or not.
Lets supose
A B
John Doe
James

Using my query I will get this result
John,Doe
James,

How can I modify it to check if column B is Null or not because I do not want the "," as shown on the second line.
This is what I have so far.



Note: IIf(IsNull([RecheckNote]) Or [RecheckNote] Like "",[CTNote],[RecheckNote] & "," & [CTnote])
Thanks in advanced

[June7]

Will there always be a value in column A (RecheckNote)? If not, then need to check for value in both columns and only use comma if there are both.

[JRCharlie]

Thanks June7 for your reply
Column A and B both can be Null .
or just A can have a value while B is null
or B Can have a Value and A is null.

[June7]

[RecheckNote] & IIf(Not IsNull([RecheckNote]) And Not IsNull([CTNote]), ",","") & [CTNote]

[JRCharlie]

Thank you June7 It works just I wanted