combine 2 different columns into one in Access 2000 query

[Guest]

I have two columns I want to combine into 1. I want to do this in a query.
1 Company 2 Property into 3 CoProp "trim[[site]]"+"trim
[primary]"is wrong.

 

[Guest]

Try

NewFieldName : trim([site]) & trim([primary])

If you want to add space between the fileds then
NewFieldName : trim([site]) & " " & trim([primary])

 

[Guest]

Ofer
Thanks for the reply. I have tried the formua you gave me. But I get an
error message.
"The expression you entered contains invalid syntax. You must have entered
an operand without a operater. " It then highlites the second trim command
before prmary. Any help is greatly apreciated

Thank You
Jerry Brandle
(e-mail address removed)

Try

NewFieldName : trim([site]) & trim([primary])

If you want to add space between the fileds then
NewFieldName : trim([site]) & " " & trim([primary])

--
\\// Live Long and Prosper \\//
BS"D

I have two columns I want to combine into 1. I want to do this in a query.
1 Company 2 Property into 3 CoProp "trim[[site]]"+"trim
[primary]"is wrong.

 

[Guest]

Can you post your SQL?

--
\\// Live Long and Prosper \\//
BS"D

Ofer
Thanks for the reply. I have tried the formua you gave me. But I get an
error message.
"The expression you entered contains invalid syntax. You must have entered
an operand without a operater. " It then highlites the second trim command
before prmary. Any help is greatly apreciated

Thank You
Jerry Brandle
(e-mail address removed)

Try

NewFieldName : trim([site]) & trim([primary])

If you want to add space between the fileds then
NewFieldName : trim([site]) & " " & trim([primary])

--
\\// Live Long and Prosper \\//
BS"D

I have two columns I want to combine into 1. I want to do this in a query.
1 Company 2 Property into 3 CoProp "trim[[site]]"+"trim
[primary]"is wrong.

 

[Guest]

no I do not have time to send sql. But I did figure out it was the field
properties that was the problem. I was trying to combine autonumber. Thank
you for the time and effort I really apreciate it.
Jerry Brandle

Can you post your SQL?

--
\\// Live Long and Prosper \\//
BS"D

Ofer
Thanks for the reply. I have tried the formua you gave me. But I get an
error message.
"The expression you entered contains invalid syntax. You must have entered
an operand without a operater. " It then highlites the second trim command
before prmary. Any help is greatly apreciated

Thank You
Jerry Brandle
(e-mail address removed)

Try

NewFieldName : trim([site]) & trim([primary])

If you want to add space between the fileds then
NewFieldName : trim([site]) & " " & trim([primary])

--
\\// Live Long and Prosper \\//
BS"D


:

I have two columns I want to combine into 1. I want to do this in a query.
1 Company 2 Property into 3 CoProp "trim[[site]]"+"trim
[primary]"is wrong.