Query not working but appears fine

[MKH2001]

I have been pondering this one all day and can't identify the reason why it is not working.

I am using Access 2003.

My code is as follows

SELECT tbl_AllSLMastr.IMSV7_COMPLGHT_UNITID, tbl_AllSLMastr.UNITTYPE, tbl_TimeTypeTrans.DESCRIPT, tbl_TimeOwnTrans.DESCRIPT, tbl_TimeScheduleTrans.DESCRIPT, tbl_CableOwnTrans.DESCRIPT, tbl_ColumnTypeTrans.DESCRIPT, tbl_AllSLMastr.HT, tbl_AllSLMastr.STNAME, tbl_AllSLMastr.ADDRQUAL, tbl_AllSLMastr.TOWN, tbl_ScoutRouteSLSR.GROUPID, tbl_ScoutRouteSLSR.GROUPDESC, Tbl_LGHTBracketImported.BRKTNO, tbl_BrktTypeTrans.DESCRIPT, Tbl_LGHTBracketImported.PROJ, Tbl_LGHTBracketImported.MOUNTHT, Tbl_LGHTLumImported.DISTTYPE, tbl_DiStTypeTrans.DESCRIPT, Tbl_LGHTLumImported_1.BALTYPE, tbl_BALTypeTrans.DESCRIPT, Tbl_LGHTLumImported_2.LAMPTYPE, tbl_LampTypeTrans.DESCRIPT, Tbl_LGHTLumImported.LAMPWATT, Tbl_LGHTLumImported.LAMPNO
FROM (((Tbl_LGHTLumImported RIGHT JOIN ((((((((tbl_ScoutRouteSLSR INNER JOIN tbl_AllSLMastr ON tbl_ScoutRouteSLSR.COMPKEY = tbl_AllSLMastr.COMPKEY) LEFT JOIN tbl_TimeTypeTrans ON tbl_AllSLMastr.TIMERTYPE = tbl_TimeTypeTrans.CODE) LEFT JOIN tbl_TimeScheduleTrans ON tbl_AllSLMastr.TIMERSCHED = tbl_TimeScheduleTrans.CODE) LEFT JOIN tbl_TimeOwnTrans ON tbl_AllSLMastr.TIMEROWN = tbl_TimeOwnTrans.CODE) LEFT JOIN tbl_CableOwnTrans ON tbl_AllSLMastr.CABLOWN = tbl_CableOwnTrans.CODE) LEFT JOIN tbl_ColumnTypeTrans ON tbl_AllSLMastr.POLECLASS = tbl_ColumnTypeTrans.CODE) LEFT JOIN Tbl_LGHTBracketImported ON tbl_AllSLMastr.COMPKEY = Tbl_LGHTBracketImported.COMPKEY) LEFT JOIN tbl_BrktTypeTrans ON Tbl_LGHTBracketImported.BRKTTYPE = tbl_BrktTypeTrans.CODE) ON Tbl_LGHTLumImported.COMPKEY = tbl_AllSLMastr.COMPKEY) LEFT JOIN tbl_DiStTypeTrans ON Tbl_LGHTLumImported.DISTTYPE = tbl_DiStTypeTrans.CODE) LEFT JOIN (Tbl_LGHTLumImported AS Tbl_LGHTLumImported_1 LEFT JOIN tbl_BALTypeTrans ON Tbl_LGHTLumImported_1.BALTYPE = tbl_BALTypeTrans.CODE) ON tbl_AllSLMastr.COMPKEY = Tbl_LGHTLumImported_1.COMPKEY) LEFT JOIN (Tbl_LGHTLumImported AS Tbl_LGHTLumImported_2 LEFT JOIN tbl_LampTypeTrans ON Tbl_LGHTLumImported_2.LAMPTYPE = tbl_LampTypeTrans.CODE) ON tbl_AllSLMastr.COMPKEY = Tbl_LGHTLumImported_2.COMPKEY
WHERE (((tbl_ScoutRouteSLSR.GROUPID) Like [Forms]![frm_AssetsbySLSRRoute]![Route]) AND ((tbl_AllSLMastr.IMSV7_COMPLGHT_EXPDATE) Is Null));

The problem appears to be when it is supposed to return the BalType Description and the DiSTType description from the tbl_BALTypeTrans and tbl_DiStTypeTrans tables.

The query is doing this same process in a number of occasions and not causing any issues.

Any ideas?

 

[MKH2001]

Sorry all realized was a mistake when i created the tables.... I named them the wrong way around.

All working now.