Retrieving records from ms access for specific dates
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 = '" & ???????
next
Any ideas?
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 = '" & ???????
next
Any ideas?
Who is Participating?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
sql = "select * from cycle_history where cycle_type='cycle' and job_number='" & jobno & "' and cycle_time >= dateadd(""d"",0,#" & Now.Date.AddDays(-dy) & "#) and cycle_time < dateadd(""d"",0,#" & Now.Date.AddDays(-dy + 1) & "#) order by cycle_time desc"