Update Query

[Bobadopolis]

Hello everyone,

This ones has me really confused, I hope I explain it ok...

I have a form which is filtered by numerous combo boxes. A 'Compare' field (yes/no) allows the user to add the data to a query that is used as the RecordSource for a comparison report.

On the form is a 'Select All' button which runs an update query to set the 'Compare' field to true for every field that matches the criteria in the combo boxes (and where Compare = False).

This has worked brilliantly until the most recent field that I've added. I created a seperate query which counts the records in another table (linked by the main table's primary key; 1:M). The results are included in the main query so that I can filter the results by that.

This Counting field has been added as a criteria of the update query because this is necessary for 'Select All' to select the values in the current view/filter. When I click 'Select All' however the message reads "Operation must use an updateable query".

I guess it's a refential integrity problem or something (the PK fields are joined only by a general/standard relationship - have changed this in query view with no success). Searching this error message on the web brings up stuff about servers and the like and I'm only developing this db locally.

I've tried writing an SQL subquery with no success and think it would result in the same error anyway

Any suggestions as to the cause/solution of the problem?

Thanks a lot,

Bobadopolis

 

[RuralGuy]

Cause = Aggregating functions in queries make them non-updateable.
Solution = ???

 

[Bobadopolis]

Thanks for that RuralGuy, this does put me in a bit of a bind - coming up with an alternate solution could be interesting!!

I will ponder away....

Bobadopolis