Info for Ganesh...

Results 1 to 2 of 2

Thread: Info for Ganesh...

  1. #1
    Join Date
    Dec 1969

    Default Info for Ganesh...

    I played around a bit a figured out the code that will work for that SQL question. To insert a variable into the ORDER BY clause I used this code and it worked.<BR><BR>strSQL = "SELECT * FROM Invoice WHERE left(Company_Name,1) IN (&#039;A&#039;, &#039;B&#039;, &#039;C&#039;) ORDER BY " & strSort & ""<BR><BR>I&#039;m editing the SELECT statement out though as you suggested.<BR>Thanks again for your help

  2. #2
    Join Date
    Dec 1969

    Default wow, thanx

    that is a new info for me and thanks a lot for coming back..<BR><BR>anytime....

Posting Permissions

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