I have problem with left join
I figured out if I use left join between table A and table B the blank record from table B will be displayed as no record or blank.
But if I left join between table A and Query, if there is no matching record it will displayed #Error.

I prefer blank record to be displayed instead.

Here is my SQL:

SELECT [Equipment Maintenance].[Maintenance Date], [Equipment Maintenance].ID, [Equipment Maintenance].[DAILY/CCOW], Equipment.Type, Equipment.Model, Equipment.[Inventory Number], [Spare Parts].[Spare Parts Required], [Equipment Maintenance].[Customer/Project], [Equipment Maintenance].PM, [Equipment Maintenance].Hourmeter, [Equipment Maintenance].Start, [Equipment Maintenance].Finish, [Equipment Maintenance].Break, [Equipment Maintenance].[Maintenance Type], [Equipment Maintenance].Code, [Equipment Maintenance].[Man Power], [Equipment Maintenance].Status, [Equipment Maintenance].[Approved By], [Equipment Maintenance].Remarks, [Maintenance Description].ID, [Maintenance Description].[Customer Complaint/Findings], [Maintenance Description].[Root Cause], [Maintenance Description].Action, [Spare Parts].Quantity, [Spare Parts].[Part Number], [Spare Parts].[Serial Number], [Spare Parts].Unit, [Spare Parts].[Spare Parts Remarks], [Spare Parts].Brand, [Spare Parts].Code, [Spare Parts].Size, [WO No Query].[WO Number]


FROM ([Equipment WO] RIGHT JOIN (Equipment INNER JOIN (([Equipment Maintenance] LEFT JOIN [Maintenance Description] ON [Equipment Maintenance].ID = [Maintenance Description].[Equipment Maintenance]) LEFT JOIN [Spare Parts] ON [Maintenance Description].ID = [Spare Parts].[Maintenance Description]) ON Equipment.ID = [Equipment Maintenance].Equipment) ON [Equipment WO].ID = [Equipment Maintenance].[WO ID]) LEFT JOIN [WO No Query] ON [Equipment WO].ID = [WO No Query].ID;

if [WO ID] is blank there will be #Error shown.
But if there is matching value it will show correct [WO Number]