<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=944413315-28072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=944413315-28072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=944413315-28072003><FONT face=Arial color=#0000ff
size=2>--Susan</FONT></SPAN></DIV>
<DIV><SPAN class=944413315-28072003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Liam Meadows
[mailto:liam@energyexhausts.co.uk] <BR><B>Sent:</B> Monday, July 28, 2003 4:58
AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] Update Query Problem in Access 2000
ADP<BR><BR></FONT></DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff size=2>Its
not the view I want to update but use the views grouped value to update the
stock table</FONT></SPAN></DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff size=2>How
would you update a field in one table based on a field in another linked by
partnumber. ?</FONT></SPAN></DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff size=2>(
Not as simple as access update query)</FONT></SPAN></DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff size=2>So
TBLstock.OnorderQty.value = VIEW1.TotalQty.value + TBLstock.OnorderQty.value
with join of Partnumber</FONT></SPAN></DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff
size=2>(Above ref only).</FONT></SPAN></DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=438525009-28072003><FONT face=Arial color=#0000ff
size=2>Liam</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Arthur
Fuller<BR><B>Sent:</B> 25 July 2003 06:58<BR><B>To:</B> 'Access Developers
discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD] Update
Query Problem in Access 2000 ADP<BR><BR></FONT></DIV>
<DIV><SPAN class=731225505-25072003><FONT face=Arial color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=731225505-25072003><FONT face=Tahoma
size=2>Arthur</FONT></SPAN></DIV>
<DIV><SPAN class=731225505-25072003></SPAN><FONT face=Tahoma><FONT
size=2><SPAN class=731225505-25072003><FONT face=Arial
color=#0000ff></FONT></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=731225505-25072003> </SPAN>-----Original
Message-----<BR><B>From:</B> accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Liam
Meadows<BR><B>Sent:</B> July 24, 2003 2:21 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Update Query
Problem in Access 2000 ADP<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>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.</FONT></P>
<P><FONT face=Arial size=2>Firstly I have a view (VIEW1) which is a
grouped query listing partnumbers and an onorder qty total
</FONT><BR><FONT face=Arial size=2>VIEW1</FONT> <BR><FONT face=Arial
size=2> Partnumber</FONT>
<BR><FONT face=Arial
size=2> POQTY</FONT> </P>
<P><FONT face=Arial size=2>I want to update the stockfile onorder qty by
onorder qty+poqty</FONT> </P>
<P><FONT face=Arial size=2>STOCK</FONT> <BR><FONT face=Arial
size=2> Partnumber</FONT>
<BR><FONT face=Arial
size=2> OnOrderQty =
OnOrderQty+ View1POQty</FONT> </P>
<P><FONT face=Arial size=2>Can anyone assist ????</FONT> </P>
<P><FONT face=Arial size=2>Liam</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>