Query Error

[mohit_ranka]

Dear Friends,
I am making a program,which requires the connection string query to return the dates... to the recordset

rst.open "Select * from table1 where dates>= " & dateadd("d",-val(combo1.text),now),conn,

Here dates is of DateTime Data type in MS Access which stores dates in table1.
combo1.text is numerical....


Actually i want to get the data for all the dates in the table,before combo1.text days from now...

HELP ME,

Thanks

[brucevde]

Dates for MS Access need to be delimited by the # sign.

When converting dates to a string for this purpose, the date should be formatted to mm/dd/yyyy otherwise there will be problems on systems
which use other date formats.

rst.open "Select * from table1 where dates>= #" & Format$(dateadd("d",-val(combo1.text),now), "mm/dd/yyyy") & "#",conn,