Having trouble with unmathced query wizard

[FrustratedUser]

I have two tables, one with the same exact info as the other minus a few rows. I'm trying to use access to find which rows are missing. However, when I create a new query and do the "Find Unmatched Query Wizard" thing it doesn't yield all of the missing rows. I deleted 13 rows and it shows only 8 that I'm missing.

My question is, why isn't it showing the other five rows? And how can I get it to show them?



I'm using this tutorial btw:
http://office.microsoft.com/en-us/ac...010205132.aspx

[pbaldy]

What is the SQL of your query? Are the records in the "base" table?

[FrustratedUser]

What is the SQL of your query? Are the records in the "base" table?

I have no idea as to either of those questions. My boss just told me to do this in Access and here I am.

[FrustratedUser]

SELECT [6/11].Field2
FROM [6/11] LEFT JOIN [6/18] ON [6/11].[Field2] = [6/18].[Field2]
WHERE ((([6/18].Field2) Is Null));

Is what SQL view shows me. 6/12 and 6/18 are the names of my tables.

[pbaldy]

If you're looking at your query in design view, you can change to SQL view via an icon on the ribbon.

[pbaldy]

So are the desired records in the 6/11 table? The unmatched query should find records where Field2 exists in 6/11 but not in 6/18.

[FrustratedUser]

So are the desired records in the 6/11 table? The unmatched query should find records where Field2 exists in 6/11 but not in 6/18.

Well what I have is a list of names. I need to compare the list of names for this week with that of last week's, and find out which names aren't in the new weeks list. So neither table has desired records, they're just records. But table 6/18 has less names than 6/11, and I need access to show me which names those are out of 650. I have to do this every week and for some reason my boss wants it done in access.

Access is showing me only 8 out of the 13 I should be missing. Not sure why.

[pbaldy]

Can you post the db here? And if so, an example of a record that should be returned that isn't?

[FrustratedUser]

Can you post the db here? And if so, an example of a record that should be returned that isn't?

I'm afraid I can't, it has info that my work would not be happy with me sharing.

An example though would be just someones name, last name, first. I have another identifier I tried using to compare, which is a few unique numbers. When I used those, despite using the numbers instead of names, it wouldn't return the same exact rows! So I have no idea.

[pbaldy]

We certainly don't want anything private posted here. All I can think of is that there is a record in the 6/18 table for each of the other 5. That query technique is pretty commonly used, and is reliable. Perhaps you can post a sanitized sample db if you're still stuck? This type of thing is much easier to debug when you can put your hands on it.

[FrustratedUser]

We certainly don't want anything private posted here. All I can think of is that there is a record in the 6/18 table for each of the other 5. That query technique is pretty commonly used, and is reliable. Perhaps you can post a sanitized sample db if you're still stuck? This type of thing is much easier to debug when you can put your hands on it.

SONUVABITCH.

Further down somehow, even though the entire list is alphabetical, there are repeats randomly placed in the rows. Sorry for the trouble. Thanks. How ridiculous.

[pbaldy]

LOL! Glad you got it sorted out, and welcome to the site by the way.