Limiting number of table enteries in a query?

[Ernie Pianalto]

Hi,

How can I limit the number of enteries a query creates in a table?


Table has about 1000 enteries. I only want to work with 50 at a time.

Thanks

 

[JohnFol]

Have a look at the query properties and in particular a value called TOP