Concatenate Problem

[ehenry]

I am appending data to a table with fields:

Unique ID, Station ID, Dates

The data I am appending comes in on a daily basis with 225 rows the date being the same and then a unique station ID and some other data irrelevant to the issue. While appending the data I am creating a Unique ID as a primary key. I have this in MS Access as [Station ID] & CDBL(Date()). This concatenates the Station ID field with the Serial Date. Right now I can only add the two, not concatenate them. Here is the SQL statement. Any help would be appreciated.

DECLARE @SerialDate varchar(50)
SET @SerialDate = DATEDIFF(dd,'19000101',DATEADD(day,-1,GetDate()))

INSERT INTO Actuals ( [Unique ID], [Station ID], Dates, [Low Temp], [High Temp], [Avg Temp], HDDs, CDDs )
SELECT ([Temp].[Station ID] & @SerialDate) AS [Unique ID], Temp.[Station ID], Temp.Dates, Temp.[Low Temp], Temp.[High Temp], Temp.[Avg Temp], Temp.HDDs, Temp.CDDs
FROM Temp;


I am getting this error:

The data types varchar and varchar are incompatible in the boolean AND operator.

or a similar int and varchar when I change the data types

 

[gmmastros]

[Temp].[Station ID] [!]+[/!] @SerialDate

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom