You should have updated the SQL in code view in dreamweaver. It sounds like you may have opened the Recordset and changed it there. It would use another syntax in that case. Try using the old file attached to the previous post and update the SQL in code view in Dreamweaver and I think it would work.