eliminate data subset from query

  • Thread starter Thread starter Daniel Collison
  • Start date Start date
D

Daniel Collison

A table includes records related to patient admission episodes. I have
created a query [qry Discharges <=6/30/07 #2] that shows all admission
episodes with a discharge date <=6/30/07.

I would like to create a second query of all admissions episodes that
exclude those identified in [qry Discharge <=6/30/07 #2]

In my second query, I have identified the following as a criteria for the
admissions episode id [Admission Episode]: Not [qry Discharges <6/30/07
#2]![Admission Episode]

This results in the query prompting me to "Enter Parameter Value" and
ulitmately produces no records.

Any suggestions?
 
Daniel

?You want the records with discharge dates that are not <=6/30/07?

Have you tried >#6/30/07#?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Try this --
SELECT *
FROM YourTable LEFT JOIN [qry Discharges <=6/30/07 #2] ON
YourTable.[Admission Episode] = [qry Discharges <=6/30/07 #2].[Admission
Episode]
WHERE [qry Discharges <=6/30/07 #2].[Admission Episode] Is Null;
 
Back
Top