[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Files 6

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___