To join or not to join, that’s concatenation for you! How do you join or concatenate Access fields together for your queries or other objects (including forms and reports) is a matter of mastering the rules and knowing the operators. There are plenty of simple demonstrations and video tutorials around on the web showing you how to combine and joins fields from tables in a calculation using the concatenate principle. Most Access developers and users will use the & (ampersand) […]

Tags: Access, concatenate access, concatenate in access query, concatenate ms access, how to join text fields, joining strings in access