Creating a recordset based on another recordset

Thread View: comp.databases.ms-access

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Larry LeBlanc Thu, 15 Jul 1999 00:00

#334

Author: 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.
===================================================================

RE: Creating a recordset based on another recordset

#336

Author: JavaTex
Date: Thu, 15 Jul 1999 00:00

5 lines
1244 bytes

Existe mucho Ingles en la red, nosotros aceptamos el hecho y nos adaptamos.
Respetad lo poco que existe en Castellano. Si quiere una respuesta a su
problema, formule su pregunta en el idioma adecuado para este canal. Sin
animo de ofender
Le saluda atentamente JavaTex

Re: Creating a recordset based on another recordset

#339

Author: 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.
: ===================================================================
:
:

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads