The 3 Newes records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Bre-x" <cholotron@xxxxxxxxxxx>
Date: Fri, 11 May 2007 14:55:35 -0700

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

.

Follow-Ups:
- Re: The 3 Newes records
  - From: Steve

Prev by Date: Re: The 3 Newes records
Next by Date: Re: Cannot run a file from Access
Previous by thread: Re: need certain form data to repeat for several records
Next by thread: Re: The 3 Newes records
Index(es):
- Date
- Thread

Relevant Pages

Re: The 3 Newes records
... Change the sort of your existing query to descending. ... 22 12/01/06 Oranges ... 50 03/01/07 Organes ...
(microsoft.public.access.gettingstarted)
Re: Exclude a field from a query
... Jeff Boyce wrote: ... Are you saying that you have one field that holds only apples, ... Example I am looking for oranges, ... I created a query and selected criteria, ...
(microsoft.public.access.queries)
Re: Exclude a field from a query
... Jeff Boyce wrote: ... Are you saying that you have one field that holds only apples, ... Example I am looking for oranges, ... I created a query and selected criteria, ...
(microsoft.public.access.queries)
Re: record position in the query
... I don't know of any way to do it in a query, but it's easy to do in a report. ...
(microsoft.public.access.queries)
Exclude a field from a query
... I am trying to query the records ... based on certain criteria. ... Example I am looking for oranges, ... of the records also have apples. ...
(microsoft.public.access.queries)