Combine 2 text Fields in a query

[crystalfun]

This should be an easy one. I have a query with a text field called "Comp" and a second text field called "Dept".

I want to combine these two fields in a query so that I get the results of "Comp Dept". How do I do this to see the results in my query.

Thanks.

 

[gmmastros]

Select Field1 + ' ' + Field2
From Table

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[MA04]

Hi,

You can also have if you want to have a coma in between.
SELECT [field1] & ", " & [field2] AS Expr1
FROM Tablename;

If you want to take into consideration null values in either field:
SELECT IIf(IsNull([tablename].[fieldname1]),[tablename].[fieldname2],[tablename].[fieldname1] & IIf(IsNull([fieldname2]),"",", " & [fieldname2])) AS Expr1
FROM Tablename;

HTH,

M-.