J
Jackie
Dear Guru
I need a way to automatically send out different query reports on different weeks of each month, the month is company fiscal month not the calendar month
I can use DateAdd("d", 7/14/21/28,MonthEndDate) to define week1, week2, week3, week4.
I developed four queries, with each has a field called forecastConsumed%. For week1, query1 with 70% will be sent out, for week2, 80%, e.t.c. in the queries, there is no date info
I need to schedule a automatically run-job to send those report out every day on certain time (say, the 2:00PM). Please advise what I can do
Your assistance is highly appreciated
Jacki
I need a way to automatically send out different query reports on different weeks of each month, the month is company fiscal month not the calendar month
I can use DateAdd("d", 7/14/21/28,MonthEndDate) to define week1, week2, week3, week4.
I developed four queries, with each has a field called forecastConsumed%. For week1, query1 with 70% will be sent out, for week2, 80%, e.t.c. in the queries, there is no date info
I need to schedule a automatically run-job to send those report out every day on certain time (say, the 2:00PM). Please advise what I can do
Your assistance is highly appreciated
Jacki