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'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