Date Problem....

[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

[si_the_geek]

Please do not post duplicate threads.

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