Hi all,

I have a question here... I have a report that showing a sub total that base on few amount like (CourseFee + TravelFee + Accomodation + Others), Then how to do the Grant Total base on the Sum function that return from these amount?? (I had do it with the ordinary Sum(CourseFee + TravelFee + Accomodation + Others) but it show the wrong record with the total of whole db record. I do try to using the DSum as well but the total is not right too...

Thank you.

Regard,
alex

You'll have to create a field with something like :

Total: DSum("[Coursefee]","Yourtable”,"") + DSum("[Travelfee]","Yourtable","") + DSum("[Accomodation]","Yourtable","")


Hth

Thank you for the reply rak~~~ i had try it but it not works... the report just poping out the error message of syntax error missing operator.... Do u have any others suggestion ???

Thank you!

How are your subtotals for CourseFee , TravelFee , Accomodation , others generated. Is that done on the basis of a query or unbound textbox .
If you provide us with some more info, I'll see what changes are to be made.

Btw are all the *Fee fields numeric ?

Your Sum belongs in the GroupFooter

Thanks everyone~ I could solve my problem already ... actually why i got syntax error is because i copy the whole task and paste to the access... when i type it myself then the problem was solve! so i think is because of the encode problem between access and IE... Now i had learn a lesson.

Thanks anyway~