problem with sum in report

[horsecow]

hello


im making a an invoice form a report at the emoment. There are some headings in the ... header, and the details int he detail.

There's the amount of days, preice per day, and the total price.

I am multiplying the days by the per day price to get the price using this..

=[Length of Hire (Number)]*[Length of Hire (Week/Month)]*[Price]



it works fine.

Now, at the bottom of the report in the footer i want to have a total total price (the sum of all the toals in the detail).

I am using this:

=Sum([Length of Hire (Number)]*[Length of Hire (Week/Month)]*[Price])

Only, it isnt working. I have a feeling that the reason it isnt working is because of the brackets in my field names, for insatnce, Length of Hire (number)
I think that maybe access is interpretaing the clising bracket in that field name as the closing of the whole expression and so it isnt working,.

Im dearly hoping this is not the case, as those fields names are used throughout the entire database and i cannot rename them.

Can someone help me add up the totals?

cheers

 

[Rich]

Which footer?

 

[horsecow]

the page footer ar the bottom of the report.


EDIT,

i just did a little experimenting and found that if i put the expression in the detail then it works... but i dont want tit to be repeating. I just want it to appear once at the bottom of the report (in the footer i presume)


2nd Edit,

and heeeeey, if i put on a report footer and header then it works great.

I suppose ive solved my problem and all tyhat was needed was someone to ask "which footer?". Cheers