Update a Table From a Query

[JoeCL]

Hello!


The table Counter is the only table in the query window. I
wanted to update a field of a table from the result of a
query. How should I do this? I tried putting the Select
statement of the query to the criteria of the update
query but I am getting the error 'Operation must use an
pdateable query' Thanks.

Here's the SQL View.

UPDATE [Counter] SET [Counter].N01 = (SELECT Count(*)
FROM Survey1 WHERE 1 In (First,Second,Third,Fourth,Fifth));

Thanks.

 

[Van T. Dinh]

Instead of the Select Count(*)..., use the DCount()function.