Crystal,
Thanks, I will do that
Jim Wagner
________________________________
________________________________
From: Crystal <strive4peace2008@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thu, July 14, 2011 1:11:15 PM
Subject: Re: [MS_AccessPros] Delete query giving me error
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
>
>
>
[Non-text portions of this message have been removed]
Kamis, 14 Juli 2011
Re: [MS_AccessPros] Delete query giving me error
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar