Hi, Please help to convert the below select statement; ThanksSELECT tblProjectPractices.PracticeEID, Format([tblProjectPractices].[PracticeGPID],"000000") AS GPID,tblODSPractices.MainContact, tblProjectPractices.nAg AS x FROM tblProjectPractices INNER JOIN tblODSPractices ON tblProjectPractices.PracticeEID = tblODSPractices.PracticeEID WHERE (((tblProjectPractices.PracticeGPID)Like [forms]![frmReturns]![txtGPID] & "*")AND ((tblProjectPractices.ProjectID)=[forms]![frmReturns]![txtProject])) ORDER BY Format([tblProjectPractices].[PracticeGPID],"000000");