Hi Jim,
glad it works ... but you should remove
, *
from the first line of the SQL so it is just:
DELETE tblEventDetails.*
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Thu, 7/14/11, Jim Wagner wrote:
> 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 <
> 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
>
>
>
Tidak ada komentar:
Posting Komentar