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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing row background from external program 0
Replacing a phrase with carriage returns 1
Report Group Footer DLookUp 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
How can I Return Just One Row With a Query? 2
Mail Merge Switch - Dollars to Words 0
Access Query to import from Sharepoint 0

Top