Have the existing nested if statement and it works fine:
SELECT TimeStart.EmpNo, TimeStart.Name, TimeStart.UN, TimeStart.BU, TimeStart.Object, TimeStart.Subsidiary, TimeStart.HomeBU, TimeStart.PBDA, TimeStart.DistPay, TimeStart.GrossPay, TimeStart.Subledger, TimeStart.SubledgerType...