<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C3793F.E58D9E70">
<title>Delete query will not run</title>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>5.5 pt</w:DrawingGridHorizontalSpacing>
<w:DrawingGridVerticalSpacing>14.95 pt</w:DrawingGridVerticalSpacing>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{margin-right:0in;
mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle16
{mso-style-type:personal-reply;
mso-ansi-font-size:11.0pt;
mso-ascii-font-family:Tahoma;
mso-hansi-font-family:Tahoma;
mso-bidi-font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:.5in 1.0in .5in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US style='tab-interval:.5in'>
<!-- Converted from text/rtf format -->
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle16><font size=2 color=navy
face=Tahoma><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
Tahoma;mso-bidi-font-family:Arial'>You are referencing [tbl Ft Stockton DOI
Info] in the WHERE clause but you do not have it in the FROM clause.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=2 color=navy
face=Tahoma><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
Tahoma;mso-bidi-font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle16><font size=2 color=navy
face=Tahoma><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
Tahoma;mso-bidi-font-family:Arial'>JR<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Kaup, Chester A
[mailto:kaupca@chevrontexaco.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, September 12, 2003
2:39 PM<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [AccessD] Delete query
will not run</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>I am probably missing
something real simple here. Thought I had done this before. Keeps asking for
parameter value. Anyway here is the sql.</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>DELETE [tbl DOI data by
well].WELLNOMST, [tbl DOI data by well].WellName, [tbl DOI data by
well].APINUMBER, [tbl DOI data by well].Net, [tbl DOI data by well].Comment</span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>FROM [tbl DOI data by
well]</span></font><font color=black><span style='color:black'> <br>
</span></font><font size=2 color=black face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:black'>WHERE ((([tbl DOI data by well].WELLNOMST)=[tbl
Ft Stockton DOI Info].[WELLNOMST]));</span></font><font color=black><span
style='color:black'> </span></font><font color=black><span style='color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face="Times New Roman"><span
style='font-size:7.5pt;color:black'>No trees were killed in the sending of this
message. However a large number of electrons were terribly inconvenienced.</span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
</body>
</html>
<BR>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial">This electronic transmission is strictly confidential to TNCO, Inc. and intended solely for the addressee. It may contain information which is covered by legal, professional, or other privileges. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy, or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. While TNCO, Inc. uses virus protection, the recipient should check this email and any attachments for the presence of viruses. TNCO, Inc. accepts no liability for any damage caused by any virus transmitted by this email.</FONT></P>