I have built a query that holds daily information. At the end of the reporting, I created a macro that runs the query and sends the data out in email form. The method used in the query is date() -1
which works great, until you do it on a monday- when trying to report for previous friday. The email goes out with blank data fields. Because no work is performed on Sunday. Any ideas how to make this work? I am trying to use the macro on monday so it reports on the previous friday- or if monday is a holiday to report tuesday for the previous friday. I hope this makes sense.
Edited by rivekm, 12 September 2007 - 09:46 AM.