Access: Combine Text - AdvantEdge Training & Consulting

Access: Combine Text

To combine text in Access, there is no Concatenate function, like there is in Excel. You must use the & symbol, instead.
The formula would be written as such: =[City]&”, “&[State]&” “&[Zip Code]
The results of this example would calculate to Centennial, CO 80112. This same formula can be used in a query, as well.

For more techniques to make your databases work for you, take an Access class from AdvantEdge Training and Consulting

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top