[AccessD] Delete query will not run

Asking for unexpected parameter values usually means a typo in a field name 
for me.  Also I see no Join info in your SQL. You're trying to delete the 
records in one table if they have a certain value in a joined table? Where's 
the join then?



Gary Kjos
garykjos at hotmail.com





>From: "Kaup, Chester A" <kaupca at chevrontexaco.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Delete query will not run
>Date: Fri, 12 Sep 2003 13:39:13 -0500
>
>I am probably missing something real simple here. Thought I had done
>this before. Keeps asking for parameter value. Anyway here is the sql.
>
>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
>FROM [tbl DOI data by well]
>WHERE ((([tbl DOI data by well].WELLNOMST)=[tbl Ft Stockton DOI
>Info].[WELLNOMST]));
>
>No trees were killed in the sending of this message. However a large
>number of electrons were terribly inconvenienced.
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es