Date Problem....

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

VB Code:

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

Please do not post duplicate threads.

This has been answered in your other copy of this thread here.