Recent content by LimAccess

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...

Good point Markk! I'm stuck after making the two crosstab queries. How can I create a query that combines the two data sets?

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...