I think you all probably know by now that I'm working on a project. At any rate though, have something I can't get my head around again:can anyone spot the error? the immediate window shows single quotes around the concats, so if Access is reading it that way it's not the correct input. thanks!Code:Set rs = db.OpenRecordset("SELECT * FROM '" & pTblName & "' " & _ "WHERE ['" & pFldName & "'] = '" & pName & "' " & _ "ORDER BY '" & sDateFld & "'", dbOpenDynaset)