calculating total from sub-totals

[DaG]

i need to create a query from a table which has the following fields : OrderItemsID, OrderID, ItemID, Quantity, Price where OrderItemsID is the primary Key and OrderID is the foreign key.
in the query, i've done calculation for sub-totals (price and quantity) but how will i calculate the total from all the sub-totals which have the same orderID. thanks in advance

 

[thouston]

Make a new query that calls the one you have already created containing your calculated subtotals. You will now be able to group by orderID and total your subtotals.