max Field

O

Octet32

I have crosstab querry that show the max amount of each product sold for
the month.
How do I do a querry that will show the product that had the highest value
only?

thanks
 
D

Duane Hookom

I'm not sure how anyone can help without understanding anything about your
records. Are we supposed to know your definition of "highest value"? Is this
the most expensive product, greatest margin, or maximum of some fields added
or multiplied or something?

How about providing some table and field names, sample records, and desired
output?
 
Top