Query on a Recordset

Results 1 to 2 of 2

Thread: Query on a Recordset

  1. #1
    Join Date
    Dec 1969

    Default Query on a Recordset

    Is it possible to perform a query on a particular Recordset, putting the results into a new Recordset? If so, how? I haven&#039;t been able to find any info on it, so I&#039;m guessing it&#039;s not possible..<BR><BR>Thanks for any responses..

  2. #2
    Linda Pyrc Guest

    Default RE: Query on a Recordset

    It goes something like..<BR><BR>Insert INTO table (field1, field2, field3...) SELECT table2.field1, table2.field2, table2.field3... WHERE ...<BR><BR>Just a Hint: If your not too familiar with SQL statements but you have access to ACCESS.. Create a query in Access to mimic what you want to do and then view the SQL to see the syntax.

Posting Permissions

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