Results 1 to 2 of 2

Thread: select into statement

  1. #1
    Guest

    edit message

    Can I use :
    select field into temptable from table1 where...
    then :
    select field into temp2 from temptable where.....
    then:
    use temp2 to make a chart???
    this is the code I use in my access/VBA project doesn't work with vb...
    the second select has a calculation in it that is why I need two select statments.
    I have a connection open to my sql db, is this where my temptable is stored , so I can access the data for my report

    [Edited by jordan0904 on 11-06-2000 at 09:57 AM]

  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008

    SQL

    Yes you can, but why not just use Table 1 directly?

    You may need to refresh the collections after running the SQL statements or the data may not be 'visible'.

    Cheers,

    Paul
    Not nearly so tired now...

    Haven't been around much so be gentle...

Posting Permissions

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



Click Here to Expand Forum to Full Width