Compare data across years

[lvh519]

I have a very simple database of product sales. My fields are Location, Product, Customer, Date, Qty. I want to be able compare January detail this year to January detail last year. I have an extra field titled monthnumber that extracts the numeric value of the month and that is what I am sorted/grouped under. I set up parameters to filter down to the years I want to compare. My report looks great, the problem is I can't do any calcuations on the data other than add them together. Is there a better way to get this information? I am not sure how to post my data here, so any help would be greatly appreciated.

[June7]

You want to get the two years side-by-side so you can calculate a change?

One approach might be to do two queries, one for each year, then join those queries to serve as RecordSource for report.

Attachment Manager is below the Advanced post editor.

[lvh519]

You want to get the two years side-by-side so you can calculate a change?

One approach might be to do two queries, one for each year, then join those queries to serve as RecordSource for report.

Attachment Manager is below the Advanced post editor.

I have my two queries created. How do I join them? It has been YEEEAARRS since I have had to deal in VBA/SQL coding.

[June7]

Are these aggregate queries that group on the month? Do both queries have every month? If both yes, join one to the other on the month fields.

[lvh519]

Are these aggregate queries that group on the month? Do both queries have every month? If both yes, join one to the other on the month fields.

Got it. Thanks!