Retrieving records from ms access for specific dates
Posted on 2009-05-04
Given an MD Access DB with records containing a date, how can retrieve the records for a specific date? I know how to use the dateadd function to pull the records using the (-) days approach.
I want to pull records for the past 24 days, one day at a time. How can I do that?
for rw as integer =24 to 0 step -1
sql="select * from history where type='cycle' and cycle_date = '" & ???????