max Field

  • Thread starter Thread starter Octet32
  • Start date Start date
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
 
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?
 
Back
Top