Limiting output of a Query

  • Thread starter Thread starter Ernie Pianalto
  • Start date Start date
E

Ernie Pianalto

HI,

How can I limit the number of records from a query.

A table has over 1000 entries but I would like to work with 50 at a time.

Thanks
 
Try "SELECT TOP 50"... not sure how it chooses which 50 records to return,
but it's probably documented in the Help...
 
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

Limiting number of table enteries in a query? 1
Parameter Query: Limit Parameter 7
AND query 4
Limit action query 1
Defining Text field sizes in destination Make-Table Query 3
Query to show all records of one table and updated info from anoth 3
Update query 1
Output Query as an Excel file 2

Back
Top