Show is data is missing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have a nested query. THe first one shows records for date 1 (say July
29). I have a second query that shows records for date 2 (say Aug 31).

These query are then used in a third query, linked by a commom key. (Serial
Number)

What this nested monster does is show me all records where there is
information for either date specified.

What i want to do is have another query that shows me those records that are
missing information. For example, if serial number 1234 has an entry for
Jul, but not for Aug, I want to see that so I can investigate.

How can I do this?
 
See my response to post Subject: Joining two queries...Please Help.

I think a version of it will wotk for you.
 
Carlee:

An outer join of the first two queries would allow you to gain this
information. For example:

SELECT Query1.Field1, Query1.Field2, ...
FROM Query1 LEFT JOIN Query2 on Query1.SerialNumber = Query2.SerialNumber
WHERE Query2.SerialNumber Is Null

The WHERE clause will give you the records from Query1 that do not have a
match in Query2. You can use the same logic to find those records in Query2
that do not have a match in Query1, if desired.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi there,

I have a nested query. THe first one shows records for date 1 (say July
29). I have a second query that shows records for date 2 (say Aug 31).

These query are then used in a third query, linked by a commom key. (Serial
Number)

What this nested monster does is show me all records where there is
information for either date specified.

What i want to do is have another query that shows me those records that are
missing information. For example, if serial number 1234 has an entry for
Jul, but not for Aug, I want to see that so I can investigate.

How can I do this?
 
Back
Top