If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|