Query question

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Hi all,

Just a question about queries, I have made a query up where it list all the
number from a certain field. But i want the query only to show the 5
highest numbers. I have set the field to descend but how do I get it to
only show the first 5 numbers

Thanks

Greg
 
View the query properties dialog where you can specify a number or
percentage in the TOP property.
 

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query Sort 2
Counting multiple memberships 1
Unique values in two fields in query 1
Count occurrences 1
Access Dcount (multiple criteria) 3
Macro question 1
Query will not sort 6

Back
Top