Creating a summery for my report

[kchan]

Hi

I am trying to create a Access report base on a query (called query1 and the report called report1)I created earlier. I have a column called Hours in this query and I would like to calculate the total of Hours and display it at the footer of the report. I tried =sum([Hours]) and all I got is an error.

Can anyone help?

Thanks

 

[lupins46]

What is the error?

What datatype is Hours?

 

[kchan]

Hours is a number, all i am trying to do is add the hours in each record and display it at the footer using sum(). When i run the report the textbox that should display the calculation just came up as #error

 

[lupins46]

Are you sure you have put this in the report footer and not the page footer.

 

[kchan]

I put it in the page footer, didn't know there is a difference between then, thanks for that