Converting number to text for SQL

[cstimart]

I have the following SQL that works fine...

= "SELECT [ID] FROM [Data Connection TBL] WHERE ([DateSentYear]= ""1992"" AND [DateRcvdYear]= ""1992"");"

However, if I create loops to cycle thru the years, the following doesn't work?

= "SELECT [ID] FROM [Data Connection TBL] WHERE ([DateSentYear]= " & CStr(x) & " AND [DateRcvdYear]= " & CStr(y) & ");"

Is CStr not right?

 

[Gary McMaster]

Maybe:

CStr(Format(x, "yyyy"))

Gary

 

[cstimart]

Hmm...I got it to work, forcing add'l quotes.

Chr(34) & CStr(x) & Chr(34)