Limiting output of a Query

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
 
D

David Seeto via AccessMonster.com

Try "SELECT TOP 50"... not sure how it chooses which 50 records to return,
but it's probably documented in the Help...
 
Top