Hello All,
So I am trying to determine how many orders my provider entered by noon, also how many discharge orders entered by noon.
It seems Access has two common criterias I can use, And is one, and Or is another.
I want a query that gives me both the numbers of orders and discharges orders entered before noon...It seems the query I created gives me one or another.
My query has <#12:00PM# for Order by Noon...but when I enter <#12:0PM# for D/C by Noon (the Or row, I only get the total for Order by Noon (see below, 21)....
Ideally I'd like to see totals for both (Order by Noon 21 and D/C by Noon 22 - see below)
When I place<#12:00PM# for Order by Noon and D/C by Noon, on the same row, I only get records that have both Order by Noon and D/C by Noon....
How can I get both totals on my query?
<colgroup><col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;">
<col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;">
<col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;">
<col width="108" style="width: 81pt; mso-width-source: userset; mso-width-alt: 3949;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
So I am trying to determine how many orders my provider entered by noon, also how many discharge orders entered by noon.
It seems Access has two common criterias I can use, And is one, and Or is another.
I want a query that gives me both the numbers of orders and discharges orders entered before noon...It seems the query I created gives me one or another.
My query has <#12:00PM# for Order by Noon...but when I enter <#12:0PM# for D/C by Noon (the Or row, I only get the total for Order by Noon (see below, 21)....
Ideally I'd like to see totals for both (Order by Noon 21 and D/C by Noon 22 - see below)
When I place<#12:00PM# for Order by Noon and D/C by Noon, on the same row, I only get records that have both Order by Noon and D/C by Noon....
How can I get both totals on my query?
MD | VISIT TYPE | ORDER BY NOON | D/C BY NOON | |
DOE MD, JIM | IP | 22:06 | 0:10 | |
DOE MD, JIM | IP | 12:36 | 2:22 | |
DOE MD, JIM | IP | 16:17 | 6:35 | |
DOE MD, JIM | IP | 11:21 | 10:10 | |
DOE MD, JIM | IP | 10:58 | 10:20 | |
DOE MD, JIM | IP | 6:44 | 10:37 | |
DOE MD, JIM | IP | 8:29 | 10:50 | |
DOE MD, JIM | IP | 8:02 | 11:10 | |
DOE MD, JIM | IP | 10:05 | 11:14 | |
DOE MD, JIM | IP | 8:54 | 11:26 | |
DOE MD, JIM | IP | 8:29 | 11:27 | |
DOE MD, JIM | IP | 6:50 | 11:28 | |
DOE MD, JIM | IP | 7:17 | 11:30 | |
DOE MD, JIM | IP | 9:25 | 11:36 | |
DOE MD, JIM | IP | 6:47 | 11:41 | |
DOE MD, JIM | IP | 10:30 | 11:50 | |
DOE MD, JIM | IP | 12:24 | 11:52 | |
DOE MD, JIM | IP | 10:29 | 11:55 | |
DOE MD, JIM | IP | 8:21 | 11:58 | |
DOE MD, JIM | IP | 10:40 | 11:58 | |
DOE MD, JIM | IP | 11:29 | 11:59 | |
DOE MD, JIM | IP | 12:58 | 11:59 | |
DOE MD, JIM | IP | 9:21 | 12:05 | |
DOE MD, JIM | IP | 10:11 | 12:05 | |
DOE MD, JIM | IP | 10:11 | 12:18 | |
DOE MD, JIM | IP | 9:25 | 12:30 | |
DOE MD, JIM | IP | 12:26 | 12:30 | |
DOE MD, JIM | IP | 14:15 | 12:30 | |
21 | 22 | 43 |