=sum([qty]*[price]) error

[likelike2045]

[qty]*[price] <---work find
but , i want to sum up the total, it comes an error
=sum([qty]*[price])

Please take a look of the attachments.
is anyone can help me?
Thank you very much

 

[vbaInet]

Sum() doesn't work in the Page Footer likelike. This link will tell you how to do it:

http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx