Sorry for the repost but am stuck on this project and can't move on. Access DB - trying to select the MAX(ID) from my table. ASP page says cant find the field. If I remove MAX and just select ID it returns the first record (ID = 1) ID is a number field. I can do the query *within* MS Access no problem but not using ASP. Am I missing something?<BR>SQLstmt = "SELECT MAX(ID) FROM Councillors"