aggregate calculations

[P. Martin]

I am trying to use sum in my query and have been suceddful
using several expressions. I used an expression to
calculate amount and now want to sum all the amounts in my
query and label them sub-total. I have tried over and over
again, but it will only sum one record not them all. Help
please!

 

[P. Martin]

I think what you're looking for is my statement?. Like I
said I did amount:[quantity] * [unitprice] and that worked
and then I tried sub-total:amount and asked it to sum and
it will only sum one record at a time. I next have sales
tax:[sub-total] * .0925 and it works. Finally I have
payment amount:[sub-total]+[sales tax]+[shipping amount].
This final expression seemed to work. Is this my problem
that I am trying for a sub-total and grand-total? Please
advise! Thanks!!!