I have created a report to show a company's monthly throughput based off a crosstab query as follows:
TRANSFORM Nz(Sum(tbl_Throughput))+0 AS SumOfUnitsSold
SELECT tbl_Throughput, tbl_Throughput.ProductType, tbl_Throughput.State
FROM tbl_Throughput
GROUP BY tbl_Throughput.Customer...
Hi
I'm trying to create a report that compares budgeted values to actual throughput values grouped by customer, state, branch and product type.
I have created 2 crosstab queries: one for the budgeted values and one for the actual.
I've attached a picture of how I'd like the report to look...