<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>Update Query Problem in Access 2000 ADP</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">Firstly I have a view (VIEW1) which is a grouped query listing partnumbers and an onorder qty total </FONT>
<BR><FONT SIZE=2 FACE="Arial">VIEW1</FONT>
<BR><FONT SIZE=2 FACE="Arial"> Partnumber</FONT>
<BR><FONT SIZE=2 FACE="Arial"> POQTY</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I want to update the stockfile onorder qty by onorder qty+poqty</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">STOCK</FONT>
<BR><FONT SIZE=2 FACE="Arial"> Partnumber</FONT>
<BR><FONT SIZE=2 FACE="Arial"> OnOrderQty = OnOrderQty+ View1POQty</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Can anyone assist ????</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Liam</FONT>
</P>
</BODY>
</HTML>