|
-
Nov 30th, 2002, 02:51 PM
#1
Thread Starter
Addicted Member
syntax error in sql statement
I keep on getting a 'syntax error in FROM clause' from the SQL querie below.
strSQL = "Select CALIBRECORDS1.*, gauges.instrumentdescription FROM CALIBRECORDS1 join guages on CALIBRECORDS1.instrumennumber=guages.instrumennumber WHERE CALIBRECORDS1.instrumennumber=" & "'" & Form3.Text49.Text & "'"
Anyone know where the problem is ?
Any input would be appreciated.
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
|
Reply With Quote