[AccessD] Query doesn't delete

Build the query in the QBE and see what you get.  Usually there is an * - Delete * from TblName 
kinda thing.

John W. Colby
www.ColbyConsulting.com


Kaup, Chester wrote:
> Taking the distinctrow out makes no difference.
> 
> -----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.
>>
>>