i have an access table that contains the following: ID Number, Store Number, Sales Region, Item Number, Item Description, Unit Price, Units Sold and Week ending. One of the queries requires us to find the best selling products by quantity and another by units sold. I'm confused on the formula to find the best selling product by quantity. At first I thought i could find the quantity by having one field set with the Item Description and just do an expression like this: Quantity: Sum([Units Sold]). When i did the run, i came up with the same answer for both queries...Can somebody help? Thanks