Henry Simpson
hsimpson88 at hotmail.com
Fri Sep 12 16:04:25 CDT 2003
I see a '.Net' in your sql string and it's probably not ready for prime time. Microsoft is getting away from using dot net in their naming so it is probably wise to do so as well. It's Friday. Hen >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 _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus