[AccessD] Update Query Problem in Access 2000 ADP

Thu Jul 24 13:21:16 CDT 2003

Is there anyway around the problem I have in ADP update queries. I suppose I have been to use to Access MDB's but I am having problems trying to update a field from another field.

Firstly I have a view (VIEW1) which is a grouped query listing partnumbers and an onorder qty total 
VIEW1
         Partnumber
         POQTY

I want to update the stockfile onorder qty by onorder qty+poqty

STOCK
         Partnumber
         OnOrderQty = OnOrderQty+ View1POQty

Can anyone assist ????

Liam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030724/94888e65/attachment.html>