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]

tip_02_01

 

 

 

 

 

 

 

 

 

 

 

The results of this example would calculate to Centennial, CO 80112. This same formula can be used in a query, as well.

tip_02_02

 

 

For more office techniques see our MS Office Tips.