The 3 Newes records

S

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
[email protected]
 
B

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
 
Top