filter query

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

how can i ask a query to bring only the top 50 out of 100
lines?

thanks,

chris
 
Queries have a TOP n parameter you can specify.

If you've already got the query created, look at the properties: you can set
TOP there.
 
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

Calculate Percentage of Total for Category 6
Salesman Performance 3
2nd Posting Select Value In Query 3
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Select Queries 1
Query Criteria 1
joined tables in query, will not filter "no" properly 7
Prompt for properties on a query.... 5

Back
Top