how to concatenate two variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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) ||
 
In a new column in the query put something like:

NewValue: [Field1Name] & [Field2Name]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenating indexed list (returns index instead of data) 3
Concatenating two sets of records 1
How to create a bubble chart with more than 2 variables 0
Concatenating Fields 5
Concatenating produces duplicates in each record. 2
Data Type Mismatch - Concatenated Field 5
Transform and concatenation of column data 2
Concatenating multiple records into one text field 4

Back
Top