Re: Creating a recordset based on another recordset

Article View: comp.databases.ms-access

Article #339

Back to comp.databases.ms-access Previous Next

#339

From: Dev Ashish
Date: Thu, 15 Jul 1999 00:00

47 lines
2320 bytes

Hi Larry,

    Look at the Filter property of the Recordset object in help.

  < http://home.att.net/~dashish/modules/mdl0010.htm >

    -- Dev

Larry LeBlanc <larry.leblanc@sympatico.ca> wrote in message
news:vRkj3.5$PZ3.234@198.235.216.4...
: Hello,
:
: Can I open a recordset, basing myself on a previous recordset?
:
: For example,
:
:     ==============================
:     Set rstClosingValues = MYDB.OpenRecordset("SELECT DateID, FundID,
Close
: FROM Daily WHERE FundID IN
:         (SELECT FundID FROM Daily GROUP BY FundID HAVING Count(*) >=250)
: ORDER BY DateID ASC, FundID ASC;")
:
:     'The next recordset bases itself on the previous recordset.
:     Set rstDays = MYDB.OpenRecordset("SELECT DISTINCTROW DateID FROM
: rstClosingValues ORDER BY DateID;")
:     ==============================
:
: In addition to posting a follow-up to this problem, can you please e-mail
me
: directly (mailto:larry.leblanc@sympatico.ca) as I cannot follow this
: newsgroup.
:
: TIA,
:
: Larry
: --
: ===================================================================
: Larry LeBlanc, CNE-3
: Montreal, Quebec, CANADA
: mailto:larry.leblanc@sympatico.ca     (flames directed to /dev/null)
: -------------------------------------------------------------------
: This message was compiled and sent using environmentally friendly
: recycled electrons and was not tested on animals.
: ===================================================================
:
:

Technical Details

Message-ID: <e8E4k$wz#GA.263@cppssbbsa03>

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

References: <vRkj3.5$PZ3.234@198.235.216.4>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,413ef6807c596b43
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 102b1d,413ef6807c596b43
X-Google-Attributes: gid102b1d,public
X-Google-Thread: ff0ac,413ef6807c596b43
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1131f0,413ef6807c596b43
X-Google-Attributes: gid1131f0,public
From: "Dev Ashish" <dash10@hotmail.com>
Subject: Re: Creating a recordset based on another recordset
Date: 1999/07/15
Message-ID: <e8E4k$wz#GA.263@cppssbbsa03>
X-Deja-AN: 501502981
References: <vRkj3.5$PZ3.234@198.235.216.4>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-MSMail-Priority: Normal
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.modulesdaovba

Reply to Parent Message