Emailing Access Query

[akins4lyfe]

I have a query which update on a daily basis. and i am currently using the Docmd.SendObject,,,"MyQuery",,,myname@mail.com,,True. To email this query to some managers.

the criteria of the Date field of "MyQuery" is set to Date()-1. This ensure previous day queries are emailed out the following day.

Now there is a problem, some of my employee occasionally work Mondays-Sundays. "MyQuery" always miss out saturdays report.

How can i change "Myquery" date criteria to generate Friday and Saturday's report on Monday.

Thank You.

 

[SkipVought]

Please post your MyQuery query sql

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}