filter query

message from chris on 1 Jun 2004
how can i ask a query to bring only the top 50 out of 100
lines?

thanks,

chris
 
Douglas J. Steele replied to chris on 1 Jun 2004
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.
 

Archived message: filter query (MS Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.