Access concatenated string blank if any of the fields are blank
I have 3 fields, COMMENT_1, COMMENT_2 and COMMENT_3. Almost every record has a COMMENT_1, a few have COMMENT_1 & COMMENT_2 and of course even less have COMMENT_1 & COMMENT_2 & COMMENT_3. I have concatenated them in the query as Comments: [ COMMENT_1] & " "& [ COMMENT_2]& " "& [COMMENT_3]. If all three comment fields are not blank, the concatenated string shows up in the query. If COMMENT_2 or COMMENT_3 are blank, none of the comments show up and the concatenated field is blank. Can anyone see what is wrong? I have never had this happen before.