S
smeghead
I'm trying use UPDATE in a Query to update selected fields in a table with
the results of a Count(*).
I have been able to do it with INSERT INTO, but am having a hard time trying
to get it to work using UPDATE.
Here is my Append Query code:
INSERT INTO [Summary Table]
SELECT Count(*) AS [AP Total]
FROM Combined_120804
WHERE (((Combined_120804.Region)="Asia Pacific"));
This Appends the Count(*) data to the table just fine.
Can anyone suggest a way to work the SELECT Count(*) into an UPDATE
statement?
UPDATE table
SET newvalue
WHERE criteria;
the results of a Count(*).
I have been able to do it with INSERT INTO, but am having a hard time trying
to get it to work using UPDATE.
Here is my Append Query code:
INSERT INTO [Summary Table]
SELECT Count(*) AS [AP Total]
FROM Combined_120804
WHERE (((Combined_120804.Region)="Asia Pacific"));
This Appends the Count(*) data to the table just fine.
Can anyone suggest a way to work the SELECT Count(*) into an UPDATE
statement?
UPDATE table
SET newvalue
WHERE criteria;