Results 1 to 2 of 2
Thread: building a query (Access 2000)
2005-02-09, 12:42 #1
- Join Date
- Jul 2001
- Thanked 0 Times in 0 Posts
building a query (Access 2000)
Can somebody help me ? I want to build a query that gives me those products that
do not exist in the other table.I have 2 tables, products and preisliste.In the table products there are products having a code that does not exist in the table presiliste, or the code is different. In my query query1 i get the results for those products that have a corresponding code in the table presiliste.For example, the missing products are Nr 1,2,3,4,5,6,7 etx and i want
to have a query that gives me only these missing products
I attach the database
2005-02-09, 12:51 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: building a query (Access 2000)
Open your query in design view.
Double click the line joining the two tables.
Select the second option ("Include ALL records from 'products' and only those records from 'preisliste' where the joined fields are equal")
Enter Is Null in the Criteria line under the Code field from preisliste.
That's it! If you wish, you can clear the 'Show' check box for the Code field from preisliste.
You could also have created this query by clicking New in the Queries section of the database window, and selecting Find Unmatched Query Wizard. This wizard will ask you a few questions, then create the query for you.