Results 1 to 3 of 3

Thread: Queries in Visual basic

  1. Jul 4th, 2000, 09:48 AM #1
    Helen Blackburn
    Helen Blackburn is offline

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Location
    Norfolk, England
    Posts
    7

    Question

    Can some one please help. I am a bit of a beginer when it comes to data reports in visual basic. I have data reports that are based on queries in an access database, some of these queries are queries based on queries. Is there any way that i can base a query in visual basic on another query in visual basic? I am using commands and with SQL statements
    Reply With Quote Reply With Quote
  2. Jul 4th, 2000, 12:34 PM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    you should be able to query on a query:

    select * from [my query name here] where [condition]....
    Reply With Quote Reply With Quote
  3. Jul 4th, 2000, 01:00 PM #3
    RogerH
    RogerH is offline
    Lively Member
    Join Date
    Dec 1999
    Location
    Karlsruhe, Germany
    Posts
    122
    Instead of using queries: Every query is a SELECT command, right? So why don't you just use

    SELECT * FROM (SELECT * FROM (SELECT ...) WHERE ...) WHERE ...

    Roger
    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