Concatenate?

[Brand-X]

If anyone knows Excel, I'm wondering if there is something like the concatenate function in Access. if you don't know Excel, Concatenate takes various values and strings them together (i.e. Concatenate(a,b,c) would give you abc). Just wondering if I can find anything like this

 

[Rich]

=[Field1]&[Field2] etc., as the control source for an unbound textbox will do the same