Syntax Error in Query Expression

[D Rid]

here is my SQL statement:

SELECT [SPO Data Entry Table].[SPO#]
     , [Standard Brk].*
     , [Standard SubBrk].*
FROM  ([SPO Data Entry Table]
       INNER JOIN
       [Standard Brk]
  ON   [SPO Data Entry Table].[SPO#] = CDBL([Standard Brk.[SPO#]]))
       INNER JOIN
       [Standard SubBrk]
  ON   [Standard Brk].[Test #] = [Standard SubBrk].[Unit No]

when trying to run the query I get the syntax error in query expression within the FROM clause: [SPO Data Entry Table].[SPO#] = CDBL([Standard Brk.[SPO]]))

those two fields are different types
spo data entry table.SPO# = autonumber
Standard Brk.SPO = text

[NeoPa]

If you look at the reference passed to CDBL() in line #7 you'll see :

[Standard Brk.[SPO]]

The closing bracket (]) that should be after Standard Brk is found after the closing bracket of [SPO] instead. Did you not look at the error message? It's pretty clear from that what the problem is.

[D Rid]

Thank you for your help....this is new to me. I have made the changes you suggested. I am now getting a type mismatch in experssion

What am I doing wrong?

SELECT [SPO Data Entry Table].[SPO#]
     , [Standard Brk].*
     , [Standard SubBrk].*
FROM  ([SPO Data Entry Table]
       INNER JOIN
       [Standard Brk]
  ON   [SPO Data Entry Table].[SPO#] = CDBL([Standard Brk].[SPO#]))
       INNER JOIN
       [Standard SubBrk]
  ON   [Standard Brk].[Test #] = [Standard SubBrk].[Unit No]

[NeoPa]

[SPO Data Entry Table].[SPO#] is an AutoNumber field (IE. Long), but you're comparing it to a value returned from CDbl(). Use Int() or CLng() instead.

[D Rid]

I am now getting an Type mismatch error. I have used both Int() and CLng() and get the same error message for both. I appreciate all the help. Here is what my SQL statement looks like now.

SELECT [SPO Data Entry Table].[SPO#]
     , [Standard Brk].*
     , [Standard SubBrk].*
FROM   ([SPO Data Entry Table]
       INNER JOIN
       [Standard Brk]
  ON   [SPO Data Entry Table].[SPO#] = CLng([Standard Brk].[SPO#]))
       INNER JOIN
       [Standard SubBrk]
  ON   [Standard Brk].[Test #] = [Standard SubBrk].[Unit No]

[NeoPa]

I just used the time I had available fixing your post. Such a waste of your time. Please read [code] Tags Must be Used before posting again.

[NeoPa]

If you're still getting a Type Mismatch error then I would assume that both of your comparisons (Lines #7 & #10) originally had problems. Line #7 should be alright now, which leaves the obvious question :
What are the Types of the two fields referenced on line #10 ([Test #] & [Unit No])?