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

Article View: comp.databases.ms-access

Article #411

Back to comp.databases.ms-access Previous Next

#411

From: haa01
Date: Mon, 05 Jan 1998 00:00

16 lines
1659 bytes

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: <01bd19ec$53f23380$a3434ec2@PC2.interpac.be>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,a5154a870901f8cb,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,a5154a870901f8cb,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1143dd,a5154a870901f8cb,start
X-Google-Attributes: gid1143dd,public
X-Google-Thread: 102b1d,a5154a870901f8cb,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: ff0ac,a5154a870901f8cb,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10779a,a5154a870901f8cb,start
X-Google-Attributes: gid10779a,public
X-Google-Thread: fe218,a5154a870901f8cb,start
X-Google-Attributes: gidfe218,public
X-Google-Thread: f8db2,a5154a870901f8cb,start
X-Google-Attributes: gidf8db2,public
From: "haa01" <haa01@interpac.be>
Subject: finding a certain number in a column (for example the 2nd largest)
Date: 1998/01/05
Message-ID: <01bd19ec$53f23380$a3434ec2@PC2.interpac.be>
X-Deja-AN: 312976217
Reply-To: "haa01" <esmets@odl.vdab.be>
Organization: Interpac Belgium SA/NV
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