Help with Update query

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I have a table (tblstocklisting) and a query (see
below). I need the tables unconfirmed column to be
updated with values out of this query (sumofpcs). I keep
getting "Must be updateble query" error

UPDATE tblstocklisting INNER JOIN qryTOTonORder ON
tblstocklisting.Item = qryTOTonORder.[Ref No] SET
tblstocklisting.Unconfirmed = qryTOTonORder!SumOfPCS;

I do not know whats giong on - I have access to all
tables, should be no probs with permissions.

Can you help please? I am sure its something simple.

Thanks

Roger
 
A slightly strange behaviour of JET SQL: If the qryTOTonORder is not
updateable, you cannot use it as the source for an Update Query (even though
you don't actually update the data in the qryTOTonORder).

You will need to restructure the qryTOTonORder to make it updateable to be
able to use it in your UPDATE SQL.
 
Back
Top