ACCESS FEED: Re: [MS_AccessPros] Delete query giving me error

Kamis, 14 Juli 2011

Re: [MS_AccessPros] Delete query giving me error

Sorry I think I figured it out. I tried this and it seemed to work

DELETE tblEventDetails.*, *
FROM tblEventDetails INNER JOIN tblArchivedEventIDs ON tblEventDetails.EventID =
tblArchivedEventIDs.EventID;

Jim Wagner
________________________________

________________________________
From: luvmymelody <luvmymelody@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thu, July 14, 2011 11:06:15 AM
Subject: [MS_AccessPros] Delete query giving me error

Hello All,

I am getting the following error "Specifiy the table containing the records you
want to delete".

The following sql statement is based on the post number 68733. But I continue to
get the error.

DELETE tblEventDetails.EventID, *
FROM tblEventDetails INNER JOIN tblArchivedEventIDs ON tblEventDetails.EventID =
tblArchivedEventIDs.EventID
WHERE (((tblEventDetails.EventID)=[tblArchivedEventIDs].[EventID]));

I am trying to delete a set of records in a table based on values in a second
table. I am surely missing something. Does anyone see the problems?

Thank you for your help very much

Jim Wagner

[Non-text portions of this message have been removed]