The 3 Newes records

[Steve]

Change the sort of your existing query to descending. Click in the area of
your query where the tables are. A Properties dialog will appear. Set the
Top property of the query to Top 3. Create a new query with the same fields
based on the first query. Set the sort to ascending. You don't need the Top
3 property in this query. Base your form or report on the second query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Bre-x]

Hi,
I have a table that show Work Orders

Columns: WO - Date - Part ID

for each Part ID i need to query the 3 newest WO's (By Date):

wo date part id
22 12/01/06 Oranges
29 01/02/07 Oranges
44 02/20/07 Oranges
43 02/28/07 Oranges
50 03/01/07 Organes

What I need is

wo date part id
44 02/20/07 Oranges
43 02/28/07 Oranges
50 03/01/07 Organes

Regards,

Bre-x