Dropping rows where values match in two tables

**mgarret** · 05-20-2013, 01:42 PM

Hi all—

I’m a little new to access queries so any assistance is greatly appreciated.

I have two queries. There is the filed “child name” in both. I need a new query that drops all the rows in which the value in “child name” is the same in both.

Here is an example:

Query 1 Child Name

Matt Jones

Katie Smith

Larry Roberts

Nick Peets

Robert Doge

Query 2 Child Name

Matt Jones

Larry Roberts

Nick Peets

Thanks so much!

Final Product

Katie Smith
Robert Doge

**rzw0wr** · 05-20-2013, 03:46 PM

Do the name appear more than once in a table?
We would need to see you table structure.

Dale

**mgarret** · 05-20-2013, 03:57 PM

Hi. yes, they appear more than once in both tables. Is that enough info?

**rzw0wr** · 05-20-2013, 04:18 PM

We would need to see you table structure.

I would like to see why they are appearing more than once in your tables.
I am thinking you may need to restructure your tables a bit. (Normalize)

Dale

Dropping rows where values match in two tables

Thread Tools

Dropping rows where values match in two tables

Similar Threads

Dropping/deleting linked tables in VBA or query

Filtering out rows based on values in other rows

vba code to search and match table values to other table values

Cannot match same data in different tables

How to retrieve values that match between two tables?

Posting Permissions