Recent content by LimAccess

  1. L

    Grand Total for a Field Outside of Grouping Level

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

    Multiple Value Crosstab Query Report

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

    Multiple Value Crosstab Query Report

    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...
Back
Top Bottom