I am FULLY CONFIDENT of helping you solve the concatenation problem in Expression Builder. For null handling, you can use IIf
Although new to Freelancer.com, I have extensive experience in Access, SQL, VBA, XML, and allied technologies. I am completely familiar with Access Object Model and must tell you that it is very rich for programmatic manipulation.
Thanks,