Subtotal Calculation

[Love Buzz]

Hi all.

I am trying to compare the countofqueue to the subtotals for each type. But
unfortunatly the result I get is the countofqueue compared to the grand total
at the bottom of the report.

How do I get the calculation to reflect the countofqueue divided by the type
subtotal?

Thanks for your help. Here is my SQL.

SELECT [Incoming Return Item Detail].Type, [Incoming Return Item
Detail].queue, Count([Incoming Return Item Detail].queue) AS CountOfqueue,
[Queues and Descriptions].[Queue 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]
HAVING ((([Incoming Return Item Detail].Type)=[Type]));

 

[vvariety]

Hi all.

I am trying to compare the countofqueue to the subtotals for each type.  But
unfortunatly the result I get is the countofqueue compared to the grand total
at the bottom of the report.

How do I get the calculation to reflect the countofqueue divided by the type
subtotal?

Thanks for your help.  Here is my SQL.

SELECT [Incoming Return Item Detail].Type, [Incoming Return Item
Detail].queue, Count([Incoming Return Item Detail].queue) AS CountOfqueue,
[Queues and Descriptions].[Queue 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]
HAVING ((([Incoming Return Item Detail].Type)=[Type]));

Are you looking for the result to be in a report?