Query Criteria

[LibbyB]

I am trying to create a query but can't get the criteria set up correctly...

I'd like to run a query for our patients who have been charged code (X or Y)
AND ((A) or B or C or D)

So I want patients who have X or Y and A along with codes that support A...

Any suggestions? I can get the X or Y part, but I can't get those who have X
or Y and A (and the others).

THANK YOU.
Libby

 

[John Vinson]

I am trying to create a query but can't get the criteria set up correctly...

I'd like to run a query for our patients who have been charged code (X or Y)
AND ((A) or B or C or D)

So I want patients who have X or Y and A along with codes that support A...

Any suggestions? I can get the X or Y part, but I can't get those who have X
or Y and A (and the others).

THANK YOU.
Libby

Please post the SQL of the query you have so far. This post is much
too abstract to give me any clear indication of what field is being
searched, how the tables are structured, or much of anything that
would allow me to post a reasonable reply.

John W. Vinson[MVP]

 

[Ofer]

Try something like

SELECT TableName.Field1, TableName.Field2
FROM TableName
WHERE (TableName.[charged code]="X" AND TableName.Field2 In
("A","B","C","D")) OR (TableName.[charged code]="Y" AND TableName.Field2 In
("A","B","C","D"))

 

[LibbyB]

Thanks for your reply... I am still learning SQL language so I am creating my
query from the "Design view" instead of SQL view. Maybe I just need to group
my criteria differently...

Thanks.
Libby

Try something like

SELECT TableName.Field1, TableName.Field2
FROM TableName
WHERE (TableName.[charged code]="X" AND TableName.Field2 In
("A","B","C","D")) OR (TableName.[charged code]="Y" AND TableName.Field2 In
("A","B","C","D"))

--
\\// Live Long and Prosper \\//
BS"D

I am trying to create a query but can't get the criteria set up correctly...

I'd like to run a query for our patients who have been charged code (X or Y)
AND ((A) or B or C or D)

So I want patients who have X or Y and A along with codes that support A...

Any suggestions? I can get the X or Y part, but I can't get those who have X
or Y and A (and the others).

THANK YOU.
Libby

 

[LibbyB]

SELECT dbo_person.last_name, dbo_person.first_name,
dbo_charges.begin_date_of_service, dbo_charges.cpt4_code_id,
dbo_charges.modifier_1, dbo_charges.quantity, dbo_charges.unit_price,
dbo_charges.amt, dbo_provider_mstr.last_name
FROM (dbo_provider_mstr INNER JOIN dbo_provider_practice_mstr ON
dbo_provider_mstr.provider_id = dbo_provider_practice_mstr.provider_id) INNER
JOIN (dbo_charges INNER JOIN (dbo_patient_encounter INNER JOIN dbo_person ON
dbo_patient_encounter.person_id = dbo_person.person_id) ON
dbo_charges.person_id = dbo_patient_encounter.person_id) ON
(dbo_provider_mstr.provider_id = dbo_charges.rendering_id) AND
(dbo_provider_practice_mstr.practice_id = dbo_charges.practice_id)
WHERE (((dbo_charges.cpt4_code_id)="27447" Or
(dbo_charges.cpt4_code_id)="27130") AND ((dbo_charges.modifier_1)="lt" Or
(dbo_charges.modifier_1)="rt")) OR (((dbo_charges.cpt4_code_id)="27447" Or
(dbo_charges.cpt4_code_id)="27130") AND ((dbo_charges.modifier_1)="lt" Or
(dbo_charges.modifier_1)="rt")) OR (((dbo_charges.cpt4_code_id)="27447" Or
(dbo_charges.cpt4_code_id)="27130") AND ((dbo_charges.modifier_1)="lt" Or
(dbo_charges.modifier_1)="rt")) OR (((dbo_charges.cpt4_code_id)="27447" Or
(dbo_charges.cpt4_code_id)="27130") AND ((dbo_charges.modifier_1)="lt" Or
(dbo_charges.modifier_1)="rt")) OR (((dbo_charges.cpt4_code_id)="27447" Or
(dbo_charges.cpt4_code_id)="27130") AND ((dbo_charges.modifier_1)="lt" Or
(dbo_charges.modifier_1)="rt")) OR (((dbo_charges.cpt4_code_id)="27447" Or
(dbo_charges.cpt4_code_id)="27130") AND ((dbo_charges.modifier_1)="lt" Or
(dbo_charges.modifier_1)="rt"))
GROUP BY dbo_person.last_name, dbo_person.first_name,
dbo_charges.begin_date_of_service, dbo_charges.cpt4_code_id,
dbo_charges.modifier_1, dbo_charges.quantity, dbo_charges.unit_price,
dbo_charges.amt, dbo_provider_mstr.last_name
HAVING (((dbo_charges.begin_date_of_service)>"20050501") AND
((dbo_provider_mstr.last_name)="Doctor6")) OR
(((dbo_charges.begin_date_of_service)>"20050501") AND
((dbo_provider_mstr.last_name)="Doctor5")) OR
(((dbo_charges.begin_date_of_service)>"20050501") AND
((dbo_provider_mstr.last_name)="Doctor4")) OR
(((dbo_charges.begin_date_of_service)>"20050501") AND
((dbo_provider_mstr.last_name)="Doctor3")) OR
(((dbo_charges.begin_date_of_service)>"20050501") AND
((dbo_provider_mstr.last_name)="Doctor2")) OR
(((dbo_charges.begin_date_of_service)>"20050501") AND
((dbo_provider_mstr.last_name)="Doctor1"))
ORDER BY dbo_person.last_name;

 

[Ofer]

In the query design view, you can write in the citeria section of the fields

Field: charged code Field2
Criteria1: "X" In ("A","B","C","D")
Criteria2: "Y" In ("A","B","C","D")

--
\\// Live Long and Prosper \\//
BS"D

Thanks for your reply... I am still learning SQL language so I am creating my
query from the "Design view" instead of SQL view. Maybe I just need to group
my criteria differently...

Thanks.
Libby

Try something like

SELECT TableName.Field1, TableName.Field2
FROM TableName
WHERE (TableName.[charged code]="X" AND TableName.Field2 In
("A","B","C","D")) OR (TableName.[charged code]="Y" AND TableName.Field2 In
("A","B","C","D"))

--
\\// Live Long and Prosper \\//
BS"D

I am trying to create a query but can't get the criteria set up correctly...

I'd like to run a query for our patients who have been charged code (X or Y)
AND ((A) or B or C or D)

So I want patients who have X or Y and A along with codes that support A...

Any suggestions? I can get the X or Y part, but I can't get those who have X
or Y and A (and the others).

THANK YOU.
Libby