Query: And/Or Criteria Vs. Totals

[Manny74]

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?

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

<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>

 

[xenou]

Hi as a rule in cases like this (where criteria is possibly at odds), you should write two queries for this. If you want to you can "combine" them into a single report after that.

 

[UncleCatwoman]

I agree. I would build a query to add the category I want to classify the record in (for example 'morning' for before noon) then run a second query totaling by category.