Total and subtotal query

[aymanmb]

I have an "order" table that has Qty, unitcost, and totalcost as fields. I want

a) make a query to calculate total cost in same table

b) make a subtotal query (like the the one in northwind sample database) tp use in my main form to claculate grand total of all orders

appreciate guiding me and include code sample if needed

thanks