Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    5

    Question Unanswered: how can i do this...?

    i just wanna know how u can do this... i just want to have a variable say "username" as each user has their own table (Access 2000) how can i select the table by using the variale in the below statment

    strSQL = "Select * FROM (USERNAME VAR HERE) WHERE" _
    & "WHERE Topic_Number=1;"

    any help would greatly appreciated

  2. #2
    Join Date
    Feb 2003
    Posts
    9
    strSQL = "Select * FROM (" &Session("username") &") WHERE" _
    & "WHERE Topic_Number=1;"

  3. #3
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    SELECT * FROM " & Session("username") & " WHERE Topic_Number = 1;

Posting Permissions

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