Concatenate

[Echo_3]

I needd to concatenate two fields. Why isn't this working?

SELECT Concatenate([Beach Contracts with Name].[Contract#],[Beach Contracts with Name].[Add-On]) AS ContractGuide
FROM [Beach Contracts with Name];

 

[Graham T]

Echo_3

Try with:

SELECT [Beach Contracts with Name].[Contract#], [Beach Contracts with Name].[Add-On], [Contract#] & [Add-On] AS ContractGuide
FROM [Beach Contracts with Name];

HTH

[This message has been edited by Graham T (edited 05-24-2002).]

 

[Echo_3]

THANK YOU!!!!!! It works!!!!!!!!

Perfect. This is the best site to get answers for my Access questions!!