Simple Select Statement Help Me

Results 1 to 3 of 3

Thread: Simple Select Statement Help Me

  1. #1
    Wizzard Guest

    Default Simple Select Statement Help Me

    Ok, there is a small problem with my syntax, I need the clause value to be the value of the form. I created a variable of it called &#039;strAuthor &#039; I have tested every thing I just dont know how to include it.. <BR><BR>Can you tell me what is wrong please /?<BR> <BR>strRSAuthor.source = "SELECT * FROM author where author_id =(SELECT max(author_id) FROM author where author_name = &#039;& strAuthor &&#039; )"<BR><BR>I know its the way I included : author_name = &#039;& strAuthor &&#039; )"

  2. #2
    Join Date
    Dec 1969

    Default Try...

    author_name = &#039;" & strAuthor & "&#039;)"

  3. #3
    wizzard Guest

    Default RE: Try...

    Thanks very much, thats something I will make a note of. Most appreciate the quick response

Posting Permissions

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