Hey guys
My select query
Code:
SELECT stu_assn.DC_ID, stu_assn.[Occ_ID], Count(stu_assn.[Occ_ID]) AS CountOfOcc_ID
FROM (stu_assn INNER JOIN Dept_Cont ON stu_assn.DC_ID = Dept_Cont.DC_ID) INNER JOIN Local_Vars ON Dept_Cont.Aid_Year = Local_Vars.Aid_Year
WHERE (([dept_cont].[aid_year]=[local_vars].[aid_year]))
GROUP BY stu_assn.DC_ID, stu_assn.[Occ_ID];
Then I try making an update query, where it takes the count field from the select query, and inputs it into a table conditioned by the other two fields in the query (DC_ID & OCC_ID) equaling two fields in my new table.
When I do this I get an error stating that I must use an updateable query.
Any ideas?