[AccessD] Update Query Problem in Access 2000 ADP

AFAIK you cannot update such a view from an ADP file. Since it is grouped
the best you can do (with work) is update the GroupBy fields. Of course you
can do it behind the scenes with a SQL statement but not from the form. It
will take executing an update query.
 
Arthur
 
 -----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liam Meadows
Sent: July 24, 2003 2:21 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Update Query Problem in Access 2000 ADP



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/20030725/86e7cfe2/attachment-0001.html>