<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>