Create A Query That Uses Multiple Criteria

[uneek78]

I have several queries created. I have one column that takes hospitals and a second column that takes different medical issues. I want to create queries that can sort by a specific hospital and medical issues.

For example:

Hospital - PCMH
Medical Issues - Code Stroke, Hemorrhage, Pnuemothorax

or

Hospital - PCMH, RCH, LMH
Medical Issues - Code Stroke

But I don't know what exactly to put in the criteria columns to have it sort correctly. Currently I have:

Like "*PCMH"

In a column and:

Like "*Code Stroke"

in the other column if I want it to sort Code Strokes that happened at PCMH. I'm noticing that the queries aren't always showing correctly.

 

[uneek78]

Nevermind. I figured it out. If I had all the hospitals listed in different Criteria sections on one field, I made sure I listed the medical problem or problems in the adjacent fields.

If I wanted several medical issues under a specific hospital to show up I put the hospital adjacent to each medical issue.

All the fields below would be under the column Critical Result. And if I wanted a query that showed them for 2 hospitals in the hospital column I would put:

Like "*OBH" Or Like "*PCMH" or Like "*CH"

And then I would get all the Critical Results for each medical issue below. Each Medical Issue below would be in it's own criteria section under Critical Results as such:

Like "*Acute cervical spine fracture"
Like "*Code Stroke"

and so on and so on

Acute cervical spine fractureCode StrokeHydrocephalusLeaking/ruptured abdominal aortaPulmonary EmbolismTension pneumothoraxUnexplained pneumoperitoneumUnsuspected acute intracranial hemorrhage