my query working fine. i want the query to find the total showing all the rows

[tariq nawaz]

i have select query which selects the records what i need.



i just need the sum of the items on the botton of the columns.
is there any way i can change the query that it shows all the records the way they are but shows totals on end.

Regards

A learner

[pbaldy]

You would normally do that on a form/report, but my friend A.D. has a query sample here:

http://www.rogersaccesslibrary.com/f...-96c1b53c.html

[tariq nawaz]

thanks baldy you are such a great help always.

it says to have subtotal for different categories but i need grand total.
i need
1
3
5
7
8

total 22
i can do the query which is
SELECT Sum(input.Weight) AS SumOfWeight
FROM [input]
WHERE (((input.Service)="RegisteredMail"));
it gives me the total value 22 whcih i want
but i am not sure how to use that in query on the end of the line of the above list showing me all the numbers as well as well total on end.



on another query i can run which shows all the numbers in the list as i write above.
i want a query which shows me all that numbers and total on the end.
i have gone through web and tried all but no victory so far.

hope you understand my situation .
a help will be highly appreciated.

Regards

A learner

[pbaldy]

Same concept; union the two queries together.