Run a query based on a start date and end date. The date are the .

  • Thread starter Thread starter santana
  • Start date Start date
S

santana

In access 2000, I trying to run a query based on a start date and an end
date. The start date is Monday from previous week and the end date is Monday
from current week. Is there a way to automate the query?
 
In access 2000, I trying to run a query based on a start date and an end
date. The start date is Monday from previous week and the end date is
Monday from current week. Is there a way to automate the query?
Click to expand...

Monday of "this week"...
DateAdd("d", -((WeekDay(Date(), vbSunday)-2)), Date())


Monday of "last week"...
DateAdd("d", -((WeekDay(Date(), vbSunday)))-5, Date())

(both assume the week starts on Sunday)
 
Rick, I used your suggestion and i get the following error message: "The
expression you entered has a function containing the wrong number of
arguments. I used the dateadd function in the criteria of the query in the
"package approved date field" with the "Between" function.
 
Back
Top