SQL Select Statement-Space in Column Name

[ECEstudent]

Does anyone know what's wrong with this line of code?

strSQL = ("INSERT INTO " & strTable & " Select c.OrderNumber, c.Item, c.RepId, p.ProductNbr, p.Name, [tbl_LBP_Sales Location Num].[Rep Region Code] FROM CalculateTotal c, dbo_PartNew p, [tbl_LBP_Sales Location Num] WHERE ([Structure] like '*" & u & "*') AND ([ProductNbr] = '" & txtPartNumber & "')")
 
CurrentDb.Execute strSQL

It keeps giving me this error and I don't know why?...

I tried replacing the brackets around Rep Region Code with quotation marks as well as these things `` but kept getting the same error...

 

[pbaldy]

It would help to see the finished SQL:

http://www.baldyweb.com/ImmediateWindow.htm

But the error implies that the given field name doesn't exist in the table, so that's the thing to check.

 

[ECEstudent]

Figured it out Turns out I had to include the brackets in this line as well!

CurrentDb.Execute "CREATE TABLE tblTest2 " _
& "(RepId CHAR, OrderNumber CHAR, Item CHAR, ProductNbr CHAR, Name CHAR, [Rep Region Code] CHAR);" 'Rebuild tblTest2 for use

 

[ECEstudent]

Can you help me with this though? I don't understand what I should even be searching anymore...

http://www.access-programmers.co.uk/forums/showthread.php?t=250509