get data for previous Monday 1

[GROKING]

Hello,
I am looking to use a data function in a access query to get data from the previous Monday, regardless of the current day of the week.

This does not work, it only pulls last thursday.

=IIf(Weekday(Date())=2,Date()-7,Date()-Weekday(Date())-2)

any ideas??
Thanks for the assistance!

 

[PHV]

=IIf(Weekday(Date())=2,Date()-7,Date()-Weekday(Date())[!]+[/!]2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886