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

[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

 

[KARL DEWEY]

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;