Need to convert access select to sql ms.

SELECT tblLabourFiles.LabID, tblLabourFilesSettled.[Settled By], tblLabourFilesSettled.ApptDate, tblSupportStaff.Initials, tblSupportStaff.LastName, [Firstname] & " " & [lastname] AS Officer, tblLabourFiles.Disposition, tblEmployerName.EmployerName, [casenum] & [act] AS [Case], tblLabourFiles.DateDec, IIf([ApptType]=1,"Formal Appointment", IIf([ApptType]=2,"Informal Appointment","")) AS Appoint, IIf([SettledWhen]=1,"Settled prior to hearing", IIf([SettledWhen]=2,"Settled during hearing", IIf([SettledWhen]=3,"Not Settled",""))) AS Settled, tblLabourFiles.DateOpen, tblCaseType.CaseType, tblLabourFilesSettled.Narrow, [Enter officer's initials or leave blank to view all officers] AS Expr1, tblSupportStaff.LastName -------------------------------------------------------------------------------- Mathieu Alexandre Cupryk www.omegalove.com ...