Re: finding a certain number in a column (for example the 2nd largest)

Article View: comp.databases.ms-access

Article #412

Back to comp.databases.ms-access Previous Next

#412

From: Gary Labowitz
Date: Mon, 05 Jan 1998 00:00

28 lines
1999 bytes

Run a top values query for the number you want and take the first/last
record returned (depending on how you sorted them).
HTH
-- 
Gary (MCT, MCPS, MCSD)
www.enter.net/~garyl/  for references to good books.
Contribute to garyl@enter.net

haa01 <haa01@interpac.be> wrote in article
<01bd19ec$53f23380$a3434ec2@PC2.interpac.be>...
> Hi 
> 
> My name's Eli and I have a little problem
> 
> I'd like to get a certain number out of a column. For example the 4th
> largest number.
> In excel this can be done by using the function LARGE, but in access I
> haven't yet fount a corresponding function.
> 
> Does anyone know of such a function in access ?
> If not, is it hard to program in vba ?
> 
> Thanks in advance
> 
> Eli
> 
>

Technical Details

Message-ID: <01bd19f1$d33ac9e0$22d9aacc@springfield>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bd19ec$53f23380$a3434ec2@PC2.interpac.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,a5154a870901f8cb
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,a5154a870901f8cb
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 10779a,a5154a870901f8cb
X-Google-Attributes: gid10779a,public
X-Google-Thread: ff0ac,a5154a870901f8cb
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,a5154a870901f8cb
X-Google-Attributes: gid102b1d,public
X-Google-Thread: fe218,a5154a870901f8cb
X-Google-Attributes: gidfe218,public
X-Google-Thread: f8db2,a5154a870901f8cb
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 1143dd,a5154a870901f8cb
X-Google-Attributes: gid1143dd,public
From: "Gary Labowitz" <garyl@enter.net>
Subject: Re: finding a certain number in a column (for example the 2nd largest)
Date: 1998/01/05
Message-ID: <01bd19f1$d33ac9e0$22d9aacc@springfield>
X-Deja-AN: 312987111
References: <01bd19ec$53f23380$a3434ec2@PC2.interpac.be>
Organization: ENTER.NET
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,it.comp.database.access,microsoft.public.access,microsoft.public.access.chat,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.form

Reply to Parent Message