If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
eliminate data subset from query
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? |
#3
|
|||
|
|||
eliminate data subset from query
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? |
Thread Tools | |
Display Modes | |
|
|