[AccessD] Query doesn't delete

Problem solved. Query needed to look like this.

DELETE DISTINCTROW [tbl Inactive Producers Any Day Prior Month].*, [tbl Status During Prior Month].Status
FROM [tbl Inactive Producers Any Day Prior Month] INNER JOIN [tbl Status During Prior Month] ON [tbl Inactive Producers Any Day Prior Month].PID = [tbl Status During Prior Month].PID
WHERE ((([tbl Status During Prior Month].Status) In ("FL","FM","FH","SL","SM","SH","SP","PL","PM","PH","RP","RM","RH","RL")));

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, March 30, 2009 4:14 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query doesn't delete

It is probably the distinct clause.  That indicates that there are several records which could fit 
the bill and it doesn't know which one to delete.


John W. Colby
www.ColbyConsulting.com


Kaup, Chester wrote:
> When I try to run the following query I get a message Specify the Table you wish to Delete Records from. It shows the records in datasheet view. I just will not delete.
> 
> DELETE DISTINCTROW [tbl Inactive Producers Any Day Prior Month].PID, [tbl Inactive Producers Any Day Prior Month].Well_Number, [tbl Inactive Producers Any Day Prior Month].Status
> FROM [tbl Inactive Producers Any Day Prior Month] INNER JOIN [tbl Status During Prior Month] ON [tbl Inactive Producers Any Day Prior Month].PID = [tbl Status During Prior Month].PID
> WHERE ((([tbl Status During Prior Month].Status) In ("FL","FM","FH","SL","SM","SH","SP","PL","PM","PH","RP","RM","RH","RL")));
> 
> Chester Kaup
> Engineering Technician
> Kinder Morgan CO2 Company, LLP
> Office (432) 688-3797
> FAX (432) 688-3799
> 
>  
> 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