CONCATENATE

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

Hi
I am working on a querry where I need to use data from one table add @ add
"text"
In Excel it is CONCATENATE function, but I can't find it in Access.
Do you know what function to use?
Thanks
 
Hi
I am working on a querry where I need to use data from one table add @ add
"text"
In Excel it is CONCATENATE function, but I can't find it in Access.
Do you know what function to use?
Thanks
Click to expand...

Why do you need a special function?
NewField:[FieldName] & "@text"
or
NewField:[FieldName] & "@" & [OtherFieldName]
 
Great! Thank you. I didn't know
--
Greatly appreciated
Eva


KenSheridan via AccessMonster.com said:
Eva:

The concatenation operator in Access is the ampersand symbol. To add ' text'
to each value from a field in a table put something like the following in the
'field' row of a blank column in query design view:

NewFieldName: [FieldName] & " text"

Where FieldName is the name of the field in the table, and NewFieldName is
the name of the column heading you want the concatenated value to appear
under in the query's result table.

Ken Sheridan
Stafford, England
Hi
I am working on a querry where I need to use data from one table add @ add
"text"
In Excel it is CONCATENATE function, but I can't find it in Access.
Do you know what function to use?
Thanks
Click to expand...

--
Message posted via AccessMonster.com


.
Click to expand...
 
Back
Top