troubleshooting Question

Access concatenated string blank if any of the fields are blank

Avatar of LindaOKSTATE
LindaOKSTATEFlag for United States of America asked on
Microsoft Access
4 Comments1 Solution275 ViewsLast Modified:
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.


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros