Hi all.
I am sure this is an easy question. With the query below I am trying to
count the number of records in a queue, and then group the results as you
see
below. It is counting fine, but the result is not the total for that
queue.
It looks like the total for that queue for one day. For example, when I
select the range of 07/01 through 07/31, I get 22 individual totals for a
particular queue instead of just one total count for the time period I
selected.
I hope that made sense. Thanks for your help.
SELECT [Incoming Return Item Detail].Type, [Incoming Return Item
Detail].queue, Count([Incoming Return Item Detail].queue) AS CountOfqueue,
[Queues and Descriptions].[Queue Name], [Incoming Return Sources].[Source
Name]
FROM [Incoming Return Sources] INNER JOIN ([Incoming Return Item Detail]
INNER JOIN [Queues and Descriptions] ON [Incoming Return Item
Detail].queue =
[Queues and Descriptions].Queue) ON [Incoming Return Sources].Source =
[Incoming Return Item Detail].Source
WHERE ((([Incoming Return Item Detail].Date) Between [Start Date] And [End
Date]))
GROUP BY [Incoming Return Item Detail].Type, [Incoming Return Item
Detail].queue, [Queues and Descriptions].[Queue Name], [Incoming Return
Sources].[Source Name]
HAVING ((([Incoming Return Item Detail].Type)=" X937"));
|
