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.