Update a Table From a Query

  • Thread starter Thread starter JoeCL
  • Start date Start date
J

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.
 
Back
Top