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

Article View: comp.databases.ms-access

Article #413

Back to comp.databases.ms-access Previous Next

#413

From: Joe A. Hissen
Date: Mon, 05 Jan 1998 00:00

33 lines
1964 bytes

Hi Eli

The following SQL statement might work for you. 
NOTE:
Choose the topmost value, using the Descending sort.

SELECT TOP 4 Table1.Column1
FROM Table1
ORDER BY Table1.Column1 DESC;

Regards
Joe A. Hissen

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: <01bd1a2e$38ee48c0$e321aace@jah>

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: f8db2,a5154a870901f8cb
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 102b1d,a5154a870901f8cb
X-Google-Attributes: gid102b1d,public
X-Google-Thread: fe218,a5154a870901f8cb
X-Google-Attributes: gidfe218,public
X-Google-Thread: ff0ac,a5154a870901f8cb
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1143dd,a5154a870901f8cb
X-Google-Attributes: gid1143dd,public
From: "Joe A. Hissen" <jhpub@pacbell.net>
Subject: Re: finding a certain number in a column (for example the 2nd largest)
Date: 1998/01/05
Message-ID: <01bd1a2e$38ee48c0$e321aace@jah>
X-Deja-AN: 313100529
References: <01bd19ec$53f23380$a3434ec2@PC2.interpac.be>
Organization: --
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