sorting records

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have got a query that at the moment lists all risks
that are in the database. I have a field in the query
called project area that has names like CDT, PMO, SMO. I
want the query to only show the first 3 records of each
of these 'project areas'

Is there any way to do this.

Cheers

Nick
 
Depends on what you mean by "first 3". Do you have a unique, primary key
field? Is there a field that describes first, second, third,...? Are the
potential "ties" for any of the first three records? Could you share some
table and field names?
 
Hi Nick,

From what you posted I gather you have information like the following:

Projectarea otherfield
------------------ ------------------
CDT 1aa
CDT 2bb
CDT 3cc
CDT 4dd
CDT 5ee
PMO 1xx
PMO 2yy
SMO 11
SMO 22
SMO 33
SMO 44
SMO 55

The results you want are:

Projectarea otherfield
------------------ ------------------
CDT 1aa
CDT 2bb
CDT 3cc
PMO 1xx
PMO 2yy
SMO 11
SMO 22
SMO 33

If the above is correct then you check out
ACC: How to Create a Top N Values per Group Query
http://support.microsoft.com/default.aspx?scid=kb;en-us;153747

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Nick" <[email protected]>
| Sender: "Nick" <[email protected]>
| Subject: sorting records
| Date: Mon, 15 Mar 2004 07:31:58 -0800
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQKoqdmqgkByNUSRAqSX0b30Q+mBw==
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:193762
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.queries
|
| I have got a query that at the moment lists all risks
| that are in the database. I have a field in the query
| called project area that has names like CDT, PMO, SMO. I
| want the query to only show the first 3 records of each
| of these 'project areas'
|
| Is there any way to do this.
|
| Cheers
|
| Nick
|
 
Back
Top