Results 1 to 2 of 2
  1. #1
    adams.bria is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2010
    Posts
    22

    Must use updateable query

    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?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    THis link should have the answer you seek: http://allenbrowne.com/ser-61.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Need Query To Be Updateable
    By robsworld78 in forum Queries
    Replies: 11
    Last Post: 07-17-2011, 09:06 PM
  2. Operation must use an updateable query.
    By pericherlasuma in forum Access
    Replies: 1
    Last Post: 05-16-2011, 09:45 AM
  3. Non-Updateable Query
    By swalsh84 in forum Queries
    Replies: 4
    Last Post: 04-27-2011, 12:39 PM
  4. Updateable query rules
    By gg80 in forum Queries
    Replies: 7
    Last Post: 01-05-2011, 11:50 PM
  5. Operation Must use an Updateable Query
    By Lady_Jane in forum Queries
    Replies: 2
    Last Post: 12-14-2010, 03:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums