Steve, given the information..
SELECT [YourTable].[Closed Date], [YourTable].[completion date], IIf([closed date]>[completion date],"Closed",IIf(IsNull([Closed date]),"Late")) AS status
FROM [YourTable];
Always good to NOT to have spaces in Field Names as this can cause complications down...