how to concatenate two variables

[Guest]

This is an easy question

In a query I need to concatenate two variables e.g. A5 is in one column,
54435353 in another so I want it to read as A554435353.

I have done it before but can't remember how to build the expression - I
know it has something to do with vertical bars (i think) ||

 

[Rick B]

In a new column in the query put something like:

NewValue: [Field1Name] & [Field2Name]

 

[David Cox]

&

 

[John Spencer]

Field: Combined: ColumnA & ColumnB