Help, I am having nightmares about this report. It is called a Standing Report and a sample that we are currently using in excel is attached. I need to try and build this report in access. I have the queries built that will pull the data, but the report will only show 1 week at a time and I cannot get the weekending date on the report. For example, I need to provide this report every wednesday for the week prior(sun - Sat). Week 1 will only show that week. Week 2 wil have the 2 weeks showed separately and so on. At the top of the report wil have last months numbers. I know it has to be with subreports, but very confused.
Thanks
David V
PS- I'm also attaching a copy of the database. The report is listed as the Weekly Standing Report.
Thanks
David V
PS- I'm also attaching a copy of the database. The report is listed as the Weekly Standing Report.
