combine 2 different columns into one in Access 2000 query

J

Jerrybra

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.
 
O

Ofer

Try

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

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

Jerrybra

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
[email protected]

Ofer said:
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


Jerrybra said:
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.
Click to expand...
Click to expand...
 
O

Ofer

Can you post your SQL?

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


Jerrybra said:
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
[email protected]

Ofer said:
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


Jerrybra said:
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.
Click to expand...
Click to expand...
Click to expand...
 
J

Jerrybra

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

Ofer said:
Can you post your SQL?

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


Jerrybra said:
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
[email protected]

Ofer said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Top