"Find Highest and Lowest" Query

  • Thread starter Thread starter Jason W.
  • Start date Start date
J

Jason W.

I am trying to run a query that will find both the
highest and lowest priced items in a table.

I just can't seem to make it work.

Any ideas?

Thanks.
 
I am trying to run a query that will find both the
highest and lowest priced items in a table.

I just can't seem to make it work.

Any ideas?

Thanks.
Click to expand...

As criteria for the query...
WHERE YourTable.PriceField=DMax("[PriceField]","YourTable") OR
YourTable.PriceField=DMin("[PriceField]","YourTable")
 
Fred,

Just wanted to say Thanks. It worked!!!

Jason
-----Original Message-----


As criteria for the query...
WHERE YourTable.PriceField=DMax
Click to expand...
("[PriceField]","YourTable") OR
YourTable.PriceField=DMin("[PriceField]","YourTable")

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top