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

Article View: comp.databases.ms-access

Article #414

Back to comp.databases.ms-access Previous Next

#414

From: lbo
Date: Wed, 07 Jan 1998 00:00

18 lines
1712 bytes

>I'd like to get a certain number out of a column. For example the 4th

...

>If not, is it hard to program in vba ?

you could write it in vba but the easiest thing is to build a query
and then ask for the n top- or bottom-values.  you do this by
twiddling with the property window of the query.


lbo@nospam.iol.it
    ^^^^^^^
-- per rispondere eliminate la stringa "nospam." dall'address
-- to answer remove "nospam." from the email address

http://users.iol.it/lbo

Technical Details

Message-ID: <68ufil$74a@mikasa.iol.it>

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: 1143dd,a5154a870901f8cb
X-Google-Attributes: gid1143dd,public
X-Google-Thread: f8db2,a5154a870901f8cb
X-Google-Attributes: gidf8db2,public
X-Google-Thread: fe218,a5154a870901f8cb
X-Google-Attributes: gidfe218,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
From: lbo@nospam.iol.it (lbo)
Subject: Re: finding a certain number in a column (for example the 2nd largest)
Date: 1998/01/07
Message-ID: <68ufil$74a@mikasa.iol.it>
X-Deja-AN: 313570471
References: <01bd19ec$53f23380$a3434ec2@PC2.interpac.be>
Organization: Italia Online
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