Create a report in Access that compares sales for two date ranges

[Lea]

From one table I need to create a query, then a report, that compares sales
figures for the same period, different years. This report should also show
the % of variation.

 

[Larry Linson]

From one table I need to create a query,
then a report, that compares sales
figures for the same period, different years.
This report should also show the
% of variation.

What data do you have, how is it stored in tables, do you want a total for
the time periods or are you wanting to compare individual records? With
some information, it is entirely possible that someone could help you.

Larry Linson
Microsoft Access MVP

 

[Lea]

What data do you have, how is it stored in tables, do you want a total for
the time periods or are you wanting to compare individual records? With
some information, it is entirely possible that someone could help you.

Larry Linson
Microsoft Access MVP

I have sales data, one record per order, that are grouped by the month that the commission is paid. I would like to create a columnar report that shows total monthly sales figures from months in 2005 next to the sales figures for the same time period in 2006. The a column that shows a percentage of change. I know how to group the orders by time period and create a summed total for the time period in question. Lea

 

[Larry Linson]

Use your two Totals queries as data sources for a new Query to be used as
the RecordSource of your Report. Join the two Totals Queries on Month. Lay
out the Report something like

Month Sales_for_2005 Sales_for_2006 Percent_Difference

You can calculate the percent difference either in the report, as a
Calculated Control, or in the Query, as a Calculated Field.

Chances are, you will want to use Report Sorting and Grouping to sort the
records by month number, but display month name.

If my description is too cryptic, post back with questions and someone
(maybe even I) will try to clarify.

Larry Linson
Microsoft Access MVP