Selecting x# of records

[Guest]

Your assistance is appreciated.
I have been tasked to manage a backlog of workorders. I need to select the
first 200 (ie oldest) records to make a report to enable/encourage the
workers to work the oldest orders first.
This needs to be handled daily by someone less Access savvy, so I want a
query (or the SQL code) to automate this selection. (I may save the
selection to a table so I can have a snapshot of that day's workload, but I
can handle this.)
In old dBase, I would just "Copy for recno()<=200 to xxxx". How do I do
that with Access?
Thanks,
Jim Cook

 

[raskew via AccessMonster.com]

Hi -

Sample query which would return the 200 oldest records:

SELECT TOP 200 Orders.OrderID, Orders.OrderDate
FROM Orders
ORDER BY Orders.OrderDate;

HTH - Bob

 

[Guest]

Wow, so simple...
Thanks,
Jim

Hi -

Sample query which would return the 200 oldest records:

SELECT TOP 200 Orders.OrderID, Orders.OrderDate
FROM Orders
ORDER BY Orders.OrderDate;

HTH - Bob