Run-Time Error 3131 Syntax error in FROM clause (1 Viewer)

[m_sami9]

I'm facing problem about Run-Time Error 3131 Syntax error in FROM clause.

Please help me to resolve the problem.

    CurrentDb.Execute " INSERT INTO tblTestReport (TestDetailID, TestID, ReceiptID, ParticularsID, PARTICULARS, RESULT, UNITS, MALE, FEMALE, ABNORMAL, PartHead, PartHeadID) " _
        & " SELECT TestDetailID, TestID, ReceiptID, ParticularsID, PARTICULARS, RESULT, UNITS, MALE, FEMALE, ABNORMAL, PartHead, PartHeadID " _
        & " FROM tblSampleReceipts2 (tblTestDesc INNER JOIN tblTestParticulars ON tblTestDesc.TestID = tblTestParticulars.TestID) INNER JOIN tblTestDetails2 ON tblTestDesc.TestID = tblTestDetails2.TestID WHERE ReceiptID = '" & ReceiptID & "'"

 

[Minty]

Put the SQL into a string variable and debug.print it in the immediate window.
Get into the habit of doing this for all but the simplest constructions of SQL strings.

Then paste it into the query editor, it should highlight what it can't work out.

 

[cheekybuddha]

Hi,

tblSampleReceipts2 is not correctly joined - it has no JOIN clause or ON clause.

Does it need to be there at all?

If it does need to be included, then re-create the SELECT portion of the query in the query designer and copy the SQL here, and we can help you get it into a string variable

 

[m_sami9]

Hi,

tblSampleReceipts2 is not correctly joined - it has no JOIN clause or ON clause.

Does it need to be there at all?

If it does need to be included, then re-create the SELECT portion of the query in the query designer and copy the SQL here, and we can help you get it into a string variable

    CurrentDb.Execute "INSERT INTO tblTestReport ( TestDetailID, TestID, ReceiptID, ParticularsID, PARTICULARS, RESULT, UNITS, MALE, FEMALE, ABNORMAL, PartHead, PartHeadID ) " _
        & " SELECT tblTestDetails2.TestDetailID, tblTestDetails2.TestID, tblTestDetails2.ReceiptID, tblTestParticulars.ParticularsID, tblTestParticulars.PARTICULARS, tblTestParticulars.RESULT, tblTestParticulars.UNITS, tblTestParticulars.MALE, tblTestParticulars.FEMALE, tblTestParticulars.ABNORMAL, tblTestParticulars.PartHead, tblTestParticulars.PartHeadID " _
        & " FROM tblSampleReceipts2, (tblTestDesc INNER JOIN tblTestParticulars ON tblTestDesc.TestID = tblTestParticulars.TestID) INNER JOIN tblTestDetails2 ON tblTestDesc.TestID = tblTestDetails2.TestID " _
        & " WHERE ReceiptID =  " & ReceiptID & " ;"

 

[cheekybuddha]

Adding the comma might fix your query, but will it give you the result you want - it will create a cartesian product (but will be limited by the WHERE clause).

Since we have no idea of your tables and their structure it's impossible to comment.

Have you got the result you want now?

 

[m_sami9]

Adding the comma might fix your query, but will it give you the result you want - it will create a cartesian product (but will be limited by the WHERE clause).

Since we have no idea of your tables and their structure it's impossible to comment.

Have you got the result you want now?

 

[theDBguy]

Can you create your APPEND query using the query designer? If you can, you can either execute that query or take its SQL and paste it in your code.