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.