Weekly totals

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

I need help with an expression that will give me the
weekly total. I have one expression that gives me the
monthly total but I need another expression that will
give me the weekly total from the current Monday to the
current date I run the query.
Thanks in advance
 
Raj,

The expression:
Date() - weekday(Date())+2
will always return last Monday's date (I assume this is wnat you mean by
current Monday). So, your criteria should look something like:
=Date() - weekday(Date())+2 and <=Date()
Click to expand...

HTH,
Nikos
 
Nikos,
Thank you..
-----Original Message-----
Raj,

The expression:
Date() - weekday(Date())+2
will always return last Monday's date (I assume this is wnat you mean by
current Monday). So, your criteria should look something like:

HTH,
Nikos



.
Click to expand...
 
Back
Top