H
Hobbit
I have a table that contains budget/actual/prior year data
for three products. The table contains two years data.
Separate columns for units and dollars and month sold.
Each product has only one line per month.
My problem is that when I try to run a single quarter to
date query,one that sums three months of data by
product,into one that has separate columns for Budget----
Actual---Prior Yr information I get dulplication of data.
Each column should have only three rows, one for each
product (totaling three months), but my output is has 9
rows one for each product for each month. How do I get a
sum for the quarter?
for three products. The table contains two years data.
Separate columns for units and dollars and month sold.
Each product has only one line per month.
My problem is that when I try to run a single quarter to
date query,one that sums three months of data by
product,into one that has separate columns for Budget----
Actual---Prior Yr information I get dulplication of data.
Each column should have only three rows, one for each
product (totaling three months), but my output is has 9
rows one for each product for each month. How do I get a
sum for the quarter?