Sql Sekect to Access

[cr84net2]

I need to convert this SQL Select statement in to a select statement that will work with MS Access 2000. Any help would be appreciated.

strSQL = "SELECT * FROM eventCalendar WHERE " & _
"convert(datetime,convert(varchar,DatePart(yyyy, dteEventStart)) + '-' + " & _
"convert(varchar,DatePart(mm, dteEventStart)) + '-' + " & _
"convert(varchar,DatePart(dd,dteEventStart))) <= " & _ 
"'" & intYear & "-" & intMonth & "-" & y & "'" & " AND " & _ 
"convert(datetime,convert(varchar,DatePart(yyyy, dteEventEnd)) + '-' + " & _
"convert(varchar,DatePart(mm, dteEventEnd)) + '-' + " & _
"convert(varchar,DatePart(dd,dteEventEnd))) >= " & _
"'" & intYear & "-" & intMonth & "-" & y & "'" & _
"ORDER BY dteEventStart, dteEventEnd"

Thanks

 

[SQLBill]

You might do best if you post your query in a MS Access forum on this site.

-SQLBill

Posting advice: FAQ481-4875

 

[cr84net2]

Thanks, Ill try that.