eliminate data subset from query

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

"Daniel Collison" wrote in
message ...
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?

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;
--
KARL DEWEY
Build a little - Test a little


"Daniel Collison" wrote:

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?