[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.
> 
>