Try this:
Code:
SELECT tbl_Die_Inspection.ID, tbl_Die_Inspection.Dicing_lot, tbl_Die_Inspection.Part_Number, tbl_Die_Inspection.Qty_In, tbl_Die_Inspection.Qty_Out, tbl_Die_Inspection.Operator_No, tbl_Die_Inspection.Date_Time_Inspected, tbl_Die_Inspection.Work_Order_Inspection, tbl_Die_Inspection.Diffusion_Lot, tbl_Die_Inspection.Evaporation_lot,
IIf([tbl_Die_Inspection].[End] = 0, "Yes", "No") As EndOfLot
FROM tbl_Die_Inspection
ORDER BY tbl_Die_Inspection.ID DESC;
What that IIf Statement is saying is 'If the Value in End is 0 - replace it with a "Yes" - otherwise replace it with a "No".
Let me know if that works for you.