Help With Delete Query (error)

Hello everyone,

i have another task to complete,

i have two tables

and......
What i want to do is delete from tblEventTemp when a match between PermaID and Date is found, (if the record exists in tblEvent, delete from tblEventTemp)

so far i have tried this SQL
What i tried to do here is delete * from tblEventTemp and made two joins between the matching fields PermaID and Date.

The query appears to work (in datasheet) however upon execution i get an error "Could not delete from specified tables"

Any Ideas would be most welcome (to resolve my SQL), i figure this would be the easiest and most efficient way of achieving his goal, but if there are better alternatives (that work) they will be welcomes with open arms....

thanks, Dan

re: Help With Delete Query (error)

This should work:
You may want to consider renaming the "Date" field!

re: Help With Delete Query (error)

Unfortunately it says "query must have at least one destination field"?

re: Help With Delete Query (error)

Try DELETE * FROM?
Wierd one.

re: Help With Delete Query (error)

that works a treat!!

thanks