CONCATENATE

[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

 

[fredg]

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

Why do you need a special function?
NewField:[FieldName] & "@text"
or
NewField:[FieldName] & "@" & [OtherFieldName]

 

[KARL DEWEY]

"Some text" & [Field_Name] & "Some more text"

 

[Eva]

Great! Thank you. I didn't know
--
Greatly appreciated
Eva

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

--



.