Creating a recordset based on another recordset

Article View: comp.databases.ms-access

Article #334

Back to comp.databases.ms-access Previous Next

#334

From: Larry LeBlanc
Date: Thu, 15 Jul 1999 00:00

33 lines
2103 bytes

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: <vRkj3.5$PZ3.234@198.235.216.4>

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: 111a5a,413ef6807c596b43,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,413ef6807c596b43,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,413ef6807c596b43,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 1131f0,413ef6807c596b43,start
X-Google-Attributes: gid1131f0,public
From: "Larry LeBlanc" <larry.leblanc@sympatico.ca>
Subject: Creating a recordset based on another recordset
Date: 1999/07/15
Message-ID: <vRkj3.5$PZ3.234@198.235.216.4>
X-Deja-AN: 501312713
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Trace: 198.235.216.4 932043227 207.61.185.2 (Thu, 15 Jul 1999 08:53:47 EDT)
Organization: Bell Solutions
NNTP-Posting-Date: Thu, 15 Jul 1999 08:53:47 EDT
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.modulesdaovba