query error

  • Thread starter Thread starter Bob Hughes
  • Start date Start date
B

Bob Hughes

Help this is driving me crazy. I'm sure the answer is obvious, I have this
query

UPDATE TblProducts INNER JOIN QryProductId ON TblProducts.ProductID =
QryProductId.ProductID SET TblProducts.AlphaID = [QryProductId].[AlphaID];

and get this error

Operation must use an updateable query

What could be wrong?
Bob
 
You will probably find that QryProductId is a "totals"
query (has a 'group by' or similar clause). Access is a
pain for this.
Instead of doing a join on the query, use a dlookup
function for your update value
 
You are correct. I did not realize this. The silly thing is, I did not need
the totals query in the first place
Thanks for the quick reply
Bob
 
Back
Top