"Find Highest and Lowest" Query

[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.

 

[fredg]

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.

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

 

[Guest]

Fred,

Just wanted to say Thanks. It worked!!!

Jason

-----Original Message-----


As criteria for the query...
WHERE YourTable.PriceField=DMax

("[PriceField]","YourTable") OR

YourTable.PriceField=DMin("[PriceField]","YourTable")

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.