how to concatenate two variables

P

Phish76

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) ||
 
R

Rick B

In a new column in the query put something like:

NewValue: [Field1Name] & [Field2Name]
 
Top