I am working on the project and it doesn&#039t like "First(Pathname) AS FirstOfPathname", attched is my query: <BR><BR>MySQL="SELECT Part, Type, sheet, Max(lastmod) AS MaxOflastmod, First(Pathname) AS FirstOfPathname FROM " & Request.Form("txtTable") & " Where Part=&#039" & Request.Form("txtParts") & "&#039 And Type1=&#039" & Request.Form ("txtTable") & "&#039 GROUP BY Part, Type, sheet ORDER BY Type "<BR><BR>HELP.<BR><BR>Farhan Shah