syntax problems with JOIN operation

[jlabre01]

Hi,

I'm having problems with the join operation in the following statement,

SELECT Projects.InvoiceNumber FROM Projects INNER JOIN projects ON (Str(Companies.CompanyName)) = (Str(Projects.CompanyID)) WHERE (Str(Companies.CompanyName)) = (Str([Forms]![Invoice]![CompanyID]));

Any help would be greatly appreciated,

jlabre01

 

[MSAccessRookie]

Possible type-o in the query

Hi,

I'm having problems with the join operation in the following statement,

SELECT Projects.InvoiceNumber FROM Projects INNER JOIN projects ON (Str(Companies.CompanyName)) = (Str(Projects.CompanyID)) WHERE (Str(Companies.CompanyName)) = (Str([Forms]![Invoice]![CompanyID]));

Any help would be greatly appreciated,

jlabre01

I don't know if this is just a type-o in the forum question, but I think your query should have read "Projects INNER JOIN Companies". Also, your compare is in the reverse order to the JOIN, and I seem to recall that it should not be done that way

If it is a type-o then I have no other suggestions at this time