I'm working on an update query for a class registration system in ColdFusion
6.1 running against an Access 2000 datasource. In short what I need to do is
update the total for number of registrants in the class sessions table after
an edit to a registration form that may either increase or decrease the
number of participants.

I'd like to do this in a single query here's what I have thus far:

<cfquery datasource="xyz">
UPDATE pscsessions set enrollment = (select sum(pscregistration.registrants)
FROM pscregistration where pscregistration.session_id = #form.session_id#)
WHERE session_id = #form.session_id#
</cfquery>

When I test the query in Access, using real values I get an error.

Can you help point me in the right direction?

Thanks for your help,

Michael Brown
Texas Department of Aging and Disability Services