Search results

This seems like it should be very simple but I'm drawing a blank. I've tried a few different things, but none of them worked, nor did I expect them to. I have two tables: Files: FileNumber Documents: FileNumber, DocType There are a bunch of files and each file has a bunch of documents. There...

Yep this works perfectly. And the delete works too. I was just hoping to be able to generate this query in design view. (But it might not be possible for something this specific) I suppose I need to learn SQL syntax really well. Thanks for your help.

How would I generate the query I'm looking for in design view? What I tried was showing table1 and table2 linking id in one to the id in the other then dragging value3 down to the fields section and putting "N" in the criteria When I ran this, it selected all the records I was looking for...

I'm simply asking a question. How will I know which table is having the records deleted from it. Here is the Select Query: SELECT table2.value3 FROM table1 INNER JOIN table2 ON table1.id = table2.id WHERE (((table2.value3)="N")); There is no "SELECT *" here to turn into a "DELETE *"

This isn't answering my question. I know how to turn it into a DELETE query. How will I know which table is having records deleted from it? If there are two tables there, it could be either one.

How do I specify which table I'm deleting from? Unlike make-query, when I select delete-query, it doesn't popup with a prompt to type a table name.

I have two tables: table1: id, value1, value 2 table2: id, value3 I want to make a delete query that will do the following: Delete all records from table 1 that have a matching record in table2 (matched by id) where value3 in table2 is "N" So I don't want to delete anything from table2...