first 50 records

[Jim Hill]

Hello,
What is the easiest and fastest way to retrieve the data
from a database with "where MyDept=12, order by MyDate"
clauses and only first 50 records (I do not need all the
rows, if first 50 is retrieved I will change MyDept). How
can I do this either in Queries or Modules?
Thanks
Jim.

 

[Arvin Meyer]

In a query, use the TOP predicate:

SELECT TOP 50 *
FROM tblWhatever
ORDER BY IDField Acsending;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access