query with max

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in my query i have a price field and i am trying to get maximum price but i
can;t make it work any idea
 
in your design view of query, look for field group by. if it is not visible
click on view and then on totals. this will add group by field to your query
fields. now scroll down and select max for your price field. This will give
you max price. if it helps you let me know.
 
ya it worked thanks

Bawan said:
in your design view of query, look for field group by. if it is not visible
click on view and then on totals. this will add group by field to your query
fields. now scroll down and select max for your price field. This will give
you max price. if it helps you let me know.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i get the product of max. price in access2007 query? 1
Need help for a query 1
Query with Relationships not working 1
challenging query 3
New printer recommendations 2
Dmax Function (I think!) 2
Parameter Query on an expression 8
query min/max function 1

Back
Top