Join Error in Record Source for Report

[Annabelle]

I get the error "Syntax Error in Join Operation".

The record source reads

SELECT [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Join_Model&StandardFeature] FROM tbl_Reference_StandardFeatures INNER JOIN ((tbl_Reference_StandardFeatures LEFT JOIN tbl_Reference_PackageItemCC ON [tbl_Reference_StandardFeatures].[ID]=[tbl_Reference_PackageItemCC].[FeatureID]) ON [tbl_Reference_StandardFeatures].[ID]=[tbl_Join_Model&StandardFeature].[FeatureID]);

I cannot see the problem. I have reworded many times but to no avail.

Ultimately, I need the standard features to print. And some standard features contain a group of items (thus tbl_Reference_PackageItemCC).

All help appreciated very much. Thanks in advance.

 

[GumbyD]

Just a couple things to check with join errors. Make sure the datatypes are the same (text to text, etc). Make sure the field lengths are the same (usually this will not matter, but if you have data that is too long on one side it might fail). Since you are using a left join make sure the left join is carried out to the last table in the line (which I think yours is, but would need to see a screen shot to be sure). If none of that helps post the full text of the error.

GumbyD

 

[Annabelle]

Answer found

Hi,
I found the answer to my question over the holidays. Thanks so much for responding.