I have searched and searched and cannot seem to find someone with the same issue I am having. Any/all help would be greatly appreciated.
Background: I have a huge database of transactions by item. I have written a query to pull a portion of the transactions based on date/product family/etc. I have created a second query with the same parameters, but summing the sales by customer. Both queries run perfect.
Report: I want run a report based summing the individual transactions by product, then by customer. This report runs fine and is sorted by alphabetically by customer. However, I want to sort the report by total the sum of the total transactions of the customer (the reason for the second query). When I bring this in, the report begins to run fine. However, if I have multiple customers with the same total is when I have problems. Either, it adds all of them together for the sort ans only shows one customer (i.e. multiple $9,000 totals are sorted in order between $42K & $36K or groups of customers added together but sorted correctly (i.e. 2 customers with a total of $27,900, but one name shows up and sorted correctly where $27,900 should be)
Using Access 2010
Background: I have a huge database of transactions by item. I have written a query to pull a portion of the transactions based on date/product family/etc. I have created a second query with the same parameters, but summing the sales by customer. Both queries run perfect.
Report: I want run a report based summing the individual transactions by product, then by customer. This report runs fine and is sorted by alphabetically by customer. However, I want to sort the report by total the sum of the total transactions of the customer (the reason for the second query). When I bring this in, the report begins to run fine. However, if I have multiple customers with the same total is when I have problems. Either, it adds all of them together for the sort ans only shows one customer (i.e. multiple $9,000 totals are sorted in order between $42K & $36K or groups of customers added together but sorted correctly (i.e. 2 customers with a total of $27,900, but one name shows up and sorted correctly where $27,900 should be)
Using Access 2010