Limit number of rows on query

  • Thread starter Thread starter Ed Faulk
  • Start date Start date
E

Ed Faulk

I'm trying to write a query that will return no more than, say, 20 rows. In
some forms of SQL there's a simple LIMIT clause, but this doesn't seem to
exist for Access. Does anyone know how to do this?

Thanks,
Ed
 
You must log in or register to reply here.

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

Limit Rows returned in a query 2
Pass Through Query - not returning rows 1
Query Field limit 2
Selection query with MAX(textfield) and WHERE textfield LIKE 'mask 5
Aggregate Query in Access 2007 1
AND query 4
Adding my own rows to a Union Query without adding another table? 3
How can I Return Just One Row With a Query? 2

Back
Top