Hi,
I am looking to run a report every day from data a temporary table, I am planning when a form opens it runs a few lines of code to fill the temporary table with various lines (different dates) for the report.
The report will be a weekly revenue buildup, (Weekly heading across the top of the page), foe example:
Mon Tue Wed Thu etc
5.00 3.00 2.00 20.00
The code I was planning is below, however I cannot work out what to end my code with as I need the Monday to always be the Monday of the current week, then I was planning for Tuesday would be "Monday + 1" etc kind of thing, unless anyone had any better ideas please?
DoCmd.RunSQL "INSERT INTO DayFlash (D1TheDate, D1RMActual, D1FBActual) SELECT TheDate, [Accommodation]+[Other], [Food]+[Wet] FROM Revenue WHERE REVENUE.TheDate = ?????"
Many thanks,
Malcolm
I am looking to run a report every day from data a temporary table, I am planning when a form opens it runs a few lines of code to fill the temporary table with various lines (different dates) for the report.
The report will be a weekly revenue buildup, (Weekly heading across the top of the page), foe example:
Mon Tue Wed Thu etc
5.00 3.00 2.00 20.00
The code I was planning is below, however I cannot work out what to end my code with as I need the Monday to always be the Monday of the current week, then I was planning for Tuesday would be "Monday + 1" etc kind of thing, unless anyone had any better ideas please?
DoCmd.RunSQL "INSERT INTO DayFlash (D1TheDate, D1RMActual, D1FBActual) SELECT TheDate, [Accommodation]+[Other], [Food]+[Wet] FROM Revenue WHERE REVENUE.TheDate = ?????"
Many thanks,
Malcolm