Z
z.ghulam
I've designed a query which merely counts the number of different types
of orders.
What I am after is a way of getting a Grand Total which will be the Sum
of all the totals.
It sounds simple enough, but I just cannot seem to get it working - I
designed the Query using the Query builder, but have put the SQL below
if it helps.
Any help / advice would be greatly appreciated.
Cheers
SELECT [Order Type (For Combo)].[Order Type], [Order
Link].[Re-Allocations], [Order Link].[Project Work], Count(*) AS Total
FROM [Order Type (For Combo)] INNER JOIN [Order Link] ON [Order Type
(For Combo)].[Order Type ID] = [Order Link].[Order Type ID]
GROUP BY [Order Type (For Combo)].[Order Type], [Order
Link].[Re-Allocations], [Order Link].[Project Work], [Order
Link].[Order Type ID]
HAVING ((([Order Link].[Re-Allocations])=No) AND (([Order
Link].[Project Work])=No));
of orders.
What I am after is a way of getting a Grand Total which will be the Sum
of all the totals.
It sounds simple enough, but I just cannot seem to get it working - I
designed the Query using the Query builder, but have put the SQL below
if it helps.
Any help / advice would be greatly appreciated.
Cheers
SELECT [Order Type (For Combo)].[Order Type], [Order
Link].[Re-Allocations], [Order Link].[Project Work], Count(*) AS Total
FROM [Order Type (For Combo)] INNER JOIN [Order Link] ON [Order Type
(For Combo)].[Order Type ID] = [Order Link].[Order Type ID]
GROUP BY [Order Type (For Combo)].[Order Type], [Order
Link].[Re-Allocations], [Order Link].[Project Work], [Order
Link].[Order Type ID]
HAVING ((([Order Link].[Re-Allocations])=No) AND (([Order
Link].[Project Work])=No));