Updating Lines in a Query

[Yoyo]

I have created a query which is based on 2 tables.
I now want to use the query to update content as needed in one of the tables
When I try to do this it says, Operation must use an updateable query

I used the update feature but it still says must be created in updateable query

I am at a loss.....Help!!

 

[bob fitz]

Can you show us the SQL statement of your query.

 

[Yoyo]

Hi Bob, Here is the SQL.
What I want to do is be able to go in and update various fields in the enrollments table - but update it within the query. Thanks in advance

SELECT [3_Enrollments].[Employee ID], [3_Enrollments].[Participant Name], [Company Roster].NAME, [1_Program List].[Course Name], [3_Enrollments].[Enrolled Course], [Company Roster].ML_POSITION_TITLE, [Company Roster].ML_LOC_NAME, [Company Roster].ML_REPORTS_TO_NAME, [Company Roster].EMPL_STATUS, [3_Enrollments].Completed, [3_Enrollments].Canceled, [3_Enrollments].Chargeback, [3_Enrollments].Comments
FROM ([1_Program List] INNER JOIN [2_Course ID Index] ON [1_Program List].ID = [2_Course ID Index].[Program Name]) INNER JOIN (3_Enrollments LEFT JOIN [Company Roster] ON [3_Enrollments].[Employee ID] = [Company Roster].EMPLID) ON [2_Course ID Index].ID = [3_Enrollments].[Enrolled Course]
WHERE ((([3_Enrollments].[Enrolled Course]) Like "*" & [Forms]![form]![Course ID]));

 

[jpaokx]

It will be a basic question, but can I ask if you included the key field from the table you wanted to update?

 

[salgergawi]

what is the best website to learn advance Queries