Too many brackets 1

[NeilT123]

When I open the following query in design I get an error message saying "can't represent the join expression".
I understand this is a known glitch and there are too many brackets in my code but I have no idea which brackets to delete. can anyone help

SELECT tblSelect.ImpOrMetric, tblCropping.CroppingYear, tblFarmerDetails.AccountName, tblFieldDetails.FieldName, tblCropping.CropOrder, tblvariety.Variety & " " & tblvariety.StrawDisposal AS [Current Crop], qryPrevCrop4rptHH2.Variety & " " & qryPrevCrop4rptHH2.StrawDisposal AS [Previous Crop], tblCropping.CroppedArea, Round([CroppedArea]*2.47,1) AS [Cropped Area IMPERIAL], IIf([CropOrder]>1,0,[CroppedArea]) AS [Cropped Area no dup], tblFieldDetails.[SubFarm/FieldGroup], tblFieldDetails.SoilSamplingRequired, tblFieldDetails.SoilSamplingComments
FROM tblVariety INNER JOIN ((((tblFarmerDetails INNER JOIN tblFieldDetails ON tblFarmerDetails.FarmAccountNumber = tblFieldDetails.FarmAccountNumber) INNER JOIN tblSelect ON tblFarmerDetails.FarmAccountNumber = tblSelect.FarmAccountNumber) INNER JOIN qryPrevCrop4rptHH2 ON tblFieldDetails.FieldCode = qryPrevCrop4rptHH2.FieldCode) INNER JOIN tblCropping ON (tblCropping.CroppingYear = qryPrevCrop4rptHH2.[Cropping Year+1]) AND (tblFieldDetails.FieldCode = tblCropping.FieldCode)) ON tblVariety.VarietyID = tblCropping.VarietyID
WHERE (((tblCropping.CroppingYear)=[Select Cropping Year]) AND ((tblFieldDetails.SoilSamplingRequired)=Yes));

Thanks in advance

 

[PHV]

And what about this ?
SELECT ...
FROM ((((tblCropping
INNER JOIN tblVariety ON tblCropping.VarietyID = tblVariety.VarietyID)
INNER JOIN tblFieldDetails ON tblCropping.FieldCode = tblFieldDetails.FieldCode)
INNER JOIN tblFarmerDetails ON tblFieldDetails.FarmAccountNumber = tblFarmerDetails.FarmAccountNumber)
INNER JOIN tblSelect ON tblFarmerDetails.FarmAccountNumber = tblSelect.FarmAccountNumber)
INNER JOIN qryPrevCrop4rptHH2 ON tblCropping.FieldCode = qryPrevCrop4rptHH2.FieldCode AND tblCropping.CroppingYear = qryPrevCrop4rptHH2.[Cropping Year+1]
WHERE ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NeilT123]

Thank you for the prompt response. Works perfectly