Limit number of rows on query

[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

 

[KARL DEWEY]

Add TOP 20 into the SQL statement like this --
SELECT TOP 20