Susan Geller
sgeller at cce.umn.edu
Mon Jul 28 10:34:42 CDT 2003
I would execute a stored procedure to do that. The SQL in the sproc would be similar to an update query in access. Looks in BOL for a sample of a SQL server update query. Let me know if you don't know how to execute a sproc from your adp. --Susan -----Original Message----- From: Liam Meadows [mailto:liam at energyexhausts.co.uk] Sent: Monday, July 28, 2003 4:58 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Update Query Problem in Access 2000 ADP Its not the view I want to update but use the views grouped value to update the stock table How would you update a field in one table based on a field in another linked by partnumber. ? ( Not as simple as access update query) So TBLstock.OnorderQty.value = VIEW1.TotalQty.value + TBLstock.OnorderQty.value with join of Partnumber (Above ref only). Liam -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: 25 July 2003 06:58 To: 'Access Developers discussion and problem solving' Subject: RE: [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/20030728/030e831c/attachment-0001.html>