MS Access: Delete Query?

Question

Here is my task:

I have a query (call it Query A). I have created another query, or sub query from Query A--call it Query B. I used the Append Query to append Query B to another Query (Query C). Here is the tricky part: the data in Query B now needs to be deleted from Query A (the original query).

The original Query (Query A) has tens of thousands of records. Query B has thousands, so I cannot just manually remove each one. I am pretty sure I have to create another query (establish a relationship between Query A and Query B), and then I must somehow use SQL to tell Access to remove all items listed in Query B from Query A.

Does that make sense? Anyone know how to accomplish this?

Thanks if you can help!!!!!

Answer 1

make a table

Answer 2

For fields defined as Date/Time datatype, Access stores hour and minute as well as Month, Day, Year. Depending on how the data was entered, you may find it extremely difficult to find matching records. If the hour and minute were stored when adding/modifying records, then they MUST also be included in your query when looking for an exact match. If the hour and minute are not critical, you might want to change your query to use Less Than (<), Less Than Or Equal (<=), and so on. That will most likely result in a dataset containing records you want to delete. §

Answer 3

It would be very helpful if you could provide specific details about the structures of your tables (including fields), and the actual queries you currently have.