I am writing a report where I can get the sales per store per date range selected. However, I would also like to compare the days' sales to the same days in the prior year based on the selected date range. How can I have the report SELECT the data for the fields for the current year AND the prior year? The data is all coming from a single table in MS Access.