<!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.2726.2500" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>