Query Criteria Expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an expression that would state that for the Date Field it would be
for Current Work Week and then for the Previous Work Week?
 
What day of the week is the start of the Work Week? Monday? Sunday? It makes
a difference. Also what day did the first week of the year start?

The following returns 6 for today:
Debug.Print DatePart("ww",Date(),vbMonday, vbFirstJan1)
 
Sorry, sometimes I forget that people can't read my mind. I was looking for
a formula that would give me results for a work week. Instead of "Between
#1/29/07# and #2/2/07#" have a Date Serial or something that would always
pull up the previous work week totals.
 
Perhaps this is what you search for

Between DateAdd("d",1-WeekDay(Date())-6, Date()) And
DateAdd("d",1-WeekDay(Date())-2, Date())

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Criteria for select query. 2
Query Weekly Data 2
Query for previous week, Sun thru Sat, from date field 1
How to add my own functions to access 2007: to select in "build" 3
expression in criteria to automatically calculate 1
Generating system date in Query 2
Totals Query Help 2

Back
Top