View Single Post
  #1  
Old June 2nd, 2010, 06:15 PM posted to microsoft.public.access.queries
SSi308
external usenet poster
 
Posts: 42
Default Delete Query not Working

I have tried to follow many of the suggestions in other posts, but have not
been able to get this to work.

I have a table called DailyCalls and another table called PersonalCalls. A
query was set up to return calls in the DailyCalls table that match calls in
the PersonalCalls table. When I change the query to a Delete query I get the
error: Invalid bracketing of name '[PersonalCalls.PhoneNumber]'.
Here is the sql of the delete query:
DELETE DistinctRow [DailyCalls].NumberDialed
FROM DailyCalls
WHERE (((DailyCalls.NumberDialed)=[PersonalCalls.PhoneNumber]));

I tried removing brackets and also adding sqare brackets around the table
names, but get the same error.

Can anyone tell me what I have wrong?

Thanks.