[AccessD] Delete query problem

Tried your suggestion and get a message of cannot delete from specified tables. Tables are local and not open.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, August 06, 2009 4:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Delete query problem

Looks like you built a select statement and them just changed the Select to Delete.

Try removing the  "[DISTINCTROW]" and the 
", [tbl Statuses During Prior Month].Status"

-- 
Stuart

On 6 Aug 2009 at 16:25, Kaup, Chester wrote:

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com