I have a single table in a query with only one criteria. However, when I try to update a field I get the "recordset not updatable..." error message. Why???
Code:SELECT AACCUReport.PriEntityID, AACCUReport.TPName, AACCUReport.RACF_No, AACCUReport.Status FROM AACCUReport GROUP BY AACCUReport.PriEntityID, AACCUReport.TPName, AACCUReport.RACF_No, AACCUReport.Status HAVING (((AACCUReport.Status)="3"));