I have a graph which gets its data from a qryGrossIncome. Some days there is 0 GI others have GI. I want to get a graph with week ending totals for the year. 52 weeks. I want the Week to end on a Friday, so I want to have the query sum the days from Saturday to Friday and use that sum for the data point. I don't what criteria I should enter in the query grid. Any help is gratefully appreciated.
Thanks
Frank