Unmatched Qry (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:59
Joined
May 7, 2009
Messages
19,175
you need to Filter the MaterialNo:

Criteria: Not Is Null
 

Minty

AWF VIP
Local time
Today, 14:59
Joined
Jul 26, 2013
Messages
10,355
In your filter for the aircraft you need to add
"ZT-RFF" Or is Null
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:59
Joined
Oct 29, 2018
Messages
21,358
the end result is correct, the 2 lines, but i would like to still see the 6 lines, even though the right may not have any orders so the field qty should be blank
Hi. You could also try the following, just as a test.
  1. Create a query based on the left table with your left table criteria
  2. Create a query based on the right table with your right table criteria
  3. Create an unmatched query between the two above queries, but don't put any criteria in it
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 10:59
Joined
Feb 19, 2002
Messages
42,985
A LEFT join will not work the way you want it to when you have criteria against the right-side table. To force Access to return the results you want, you need two queries.
q1
Selects ONLY the right-side table using the criteria you need.
q2
Uses a left join from MatrialNo to q1 with NO criteria.

A subquery will probably work but they are difficult to build with QBE.
 

Gismo

Registered User.
Local time
Today, 16:59
Joined
Jun 12, 2017
Messages
1,298
i managed to get it working
i filtered in 2 separate queries and the 3rd just the unmatched

thank you for all the help
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:59
Joined
Oct 29, 2018
Messages
21,358
i managed to get it working
i filtered in 2 separate queries and the 3rd just the unmatched

thank you for all the help
Hi. Glad to hear you got it sorted out. Good luck with your project.
 

Users who are viewing this thread

Top Bottom