Quote:
Originally posted by Goldy
Hi.
I'm having problems creating a delete query. Each time I try to make one, the query becomes "non updatable" and therefore doesnt work.
The delete query needs to involve two tables and one query:
Table 1: Holds the key of which records to delete (eg only those with a key of "141")
Query 1: Holds calculations relating to the records to be be deleted (I only want to delete null values within a "total" calculation). This query references "Table 2".
Table 2: Is the table that needs the records deleting from.
Everytime I create a query with "Table 1 and Query 1" or "Query 1 and Table 2", it becomes unupdatable, and therefore any delete query built from it doesn't work.
Any ideas?
Thanks in advance.
Using Access 97.
|
Can you post an example of what is happening?