Another Update Criteria Scenario

[padlocked17]

All -

I have another update query that is basically looking at all of the Enrollment ID's that are associated with a ClassID. If each EnrollmendID has a Graduation date and the Graduated check = yes, then I want to place the current date in the Closed Date field for the Class.

I can get a select Query that shows all of the classes and all of the EnrollmentID's but I'm not sure how to tell the query, "For Each ClassID, If All EnrollmentID's have a Graduated Date and Graduated = Yes, Then Class Closed Date = Date()"

 

[CraigDolphin]

Try something like...

Update [YourTableName] Set [Class Closed Date] = Date()
WHERE ((([EnrollmentID] & "") <> "") AND ([Graduated] = -1));