Multiple columns

[b6104]

I have an Access database with the key being our store number and a table that captures their sales total, bank deposit, charge card deposit, etc. by sales date. I want to design a report that has the stores (58)down the side (let^s say Column A), and then 7 dates (for one week) across the top (columns B-H let^s say), and then extract their total sales. We would run this once each day after all sales have been reported. Question is both in design layout and the being able to run the report each day without having to change the filtering each time. Any suggestions would be appreciated.

[kfleming]

You could sort and group your report by store and then create 7 total fields to sum sales. Each total would use a different conditional expression based upon the required dates.____To drive the dates you could in Version 9, create a date parameteRR field. Each time that you run the report you would be prompted to enter this date.__Then you would create 7 calculated fields based upon this parameteRR field. The calculations could be simple (such as ADDAYS(startdate,1) for the startdate plus one day or more complex if you want to show only weekdays. These calculations would then be used for the conditional totals.____If you want, I can send you a small sample report showing this technique.____Kathleen__R&R Support________