Limit Rows returned in a query

N

Nigel

Is there any way to limit the number of rows returned in a query, I have some
conditions but I only want the first 5 rows returned
 
B

Bob Barrows [MVP]

Nigel said:
Is there any way to limit the number of rows returned in a query, I
have some conditions but I only want the first 5 rows returned
Click to expand...

Sure, just open the query properties page and set the relevant property. Or,
switch to SQL View and add the words "TOP 5" immediately after the word
"SELECT"
 
M

Marshall Barton

Nigel said:
Is there any way to limit the number of rows returned in a query, I have some
conditions but I only want the first 5 rows returned
Click to expand...


Check the TOP predicate in Help - Table of contents -
Microsoft Jet SQL Reference
 
Top