Results 1 to 2 of 2

Thread: Query-based Recordset

  1. Jul 28th, 2000, 11:16 AM #1
    jkurpias
    jkurpias is offline

    Thread Starter
    Lively Member
    Join Date
    May 1999
    Location
    Vancouver, BC, Canada
    Posts
    84
    In Access2000 with DAO...

    Is there a way to base a Recordset on a Query witout creating a Table?

    Jon
    Reply With Quote Reply With Quote
  2. Jul 28th, 2000, 11:30 AM #2
    DrewDog_21
    DrewDog_21 is offline
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Columbia, SC USA
    Posts
    374

    Question

    All you need to do to select data from a query is to establish the query itself in the database and then use the query name instead of a table name in your SELECT statment (e.g. "SELECT * From MyQuery ORDER BY MyField"). I don't exactly understand your problem, though. Could you explain it a little more?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width