Access Update Query - with Count function

[klarkee]

tryin to run an update query to my Price Band Table, where I want to COUNT the number of stores in the store data table, where the Price Band ID is equal in both tables.

I have been able to run this as a normal query:-

SELECT [Store Data Table].[Price Band ID], Count([Store Data Table].[Price Band ID]) AS Expr1,
FROM [Store Data Table]
GROUP BY [Store Data Table].[Price Band ID];

However to run this as an update query, I am unable to get it to work.

 

[JimHorton]

klarkee,
It's impossible to use this as an update, since each row is actually many rows aggregated together. You could use it as a sub-select statement in the criteria of another update query to update bulk sets of rows based on some aggregate value.
--Jim

 

[Nordyck]

What your trying will not work. Use your select statement as query1. Then create an update query and link the query1 to Price Brand table and setting [price band id] equal to each other.

Nordyck