Report for Max, Ave & Detail Record for Highest Sale Price by Cate

  • Thread starter Thread starter PAR
  • Start date Start date
P

PAR

I need a report showing category Max, Ave and Total gross Sales along with
the highest selling item detailed by category.

I easily created the Max, Ave & Total Gross Sales. However, I can not figure
out how to return the detailed record of the highest sale priced item per
category.

Any Ideas?

These need to be on the same report. I thought there might be a way to do a
report with a sub report which would provide the detail - using 2 queries,
but I can't figure out how to write the query for the details for category
max.

Thanks
 
the highest selling item detailed by category.Does this mean maximum total sales or maximum price?
For maximum total sales use this query named qryMaxSales --
SELECT TOP 1 Item, Sum([Sales])
FROM YourTable
ORDER BY Sum([Sales]) DESC;

and join in this --
SELECT YourTable.*
FROM YourTable INNER JOIN qryMaxSales ON YourTable.Item = qryMaxSales.Item;
 
Back
Top