Weekly totals

[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

 

[Nikos Yannacopoulos]

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()

HTH,
Nikos

 

[Raj]

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



.