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...
 
Back
Top