Unmatched Queries - Wizard works, Not Design View

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

I have a weird one here. I was trying to build a query to
find "Unmatched" records. When I created the query in
design view, it didn't work. When I created the query
using the "Find Unmatched Query Wizard" the query worked
perfectly. When I went into design view, my query and the
query that the wizard created looked identical. Is this a
bug or am I missing something obvious?

Some background:
My source table had 8,000 records and the table I was
searching has about 100 records.
 
Hi,


The SQL statement (SQL view) would tell more than the graphical
representation where a subtle detail may be missed. What is the SQL
statement of the query that does not work... and by "not work", do you mean
there is an error or it just does not return the right data?



Hoping it may help,
Vanderghast, Access MVP
 
Michel / Douglas,

Thanks for your help. I took a quick look at the SQL view
before I made the post but missed the differences between
the two queries. I thought there was something I must
have missed. Thanks for helping me find the error.

In the SQL view there are two big differences between the
queries. At one point, the Wizard does a Left Join. When
the querie was created in Design view it did an Inner
Join. Also, the design view added an * after the status.

Here's the queries as displayed in SQL View"

Wizard:
SELECT [Foster - Current Roster].Name, [Foster - Current
Roster].Status
FROM [Foster - Current Roster] LEFT JOIN [Foster - Current
History] ON [Foster - Current Roster].Name = [Foster -
Current History].Name
WHERE ((([Foster - Current History].Name) Is Null));

Design View:
SELECT [Foster - Current Roster].Name, [Foster - Current
Roster].Status, *
FROM [Foster - Current History] INNER JOIN [Foster -
Current Roster] ON [Foster - Current History].Name =
[Foster - Current Roster].Name
WHERE ((([Foster - Current History].Name) Is Null));
 
Back
Top