Limit Rows returned in a query

  • Thread starter Thread starter Nigel
  • Start date Start date
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
 
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"
 
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

How can I Return Just One Row With a Query? 2
Using IIF statement in query criteria 11
Use In() Expression as Query criteria with guts from Function 1
Left Join query returns with null values 12
Query in Access 2007 1
query return only one row with averages 4
Split data in field on character return 0
Pass Through Query - not returning rows 1

Back
Top