Sum of a column

D

Dean

I need just the sum of a column. I am using this =Sum([NO_DAYS]). Alls i
am getting is #error. NO_days is the correct field name... The coulmn
consists of only 1 and .5.

thanks
 
F

fredg

I need just the sum of a column. I am using this =Sum([NO_DAYS]). Alls i
am getting is #error. NO_days is the correct field name... The coulmn
consists of only 1 and .5.

thanks
Click to expand...

Sum the column where? In the Page Footer?

See Microsoft Knowledgebase article:
132017 'How to sum a column of numbers in a report by page'
 
D

Dean

yes it is in the page footer.....does that make a difference? Where i put
it, is no big deal as long as it's there

fredg said:
I need just the sum of a column. I am using this =Sum([NO_DAYS]). Alls i
am getting is #error. NO_days is the correct field name... The coulmn
consists of only 1 and .5.

thanks
Click to expand...

Sum the column where? In the Page Footer?

See Microsoft Knowledgebase article:
132017 'How to sum a column of numbers in a report by page'
Click to expand...
 
D

Dean

I moved it to the report footer and works fine

Dean said:
yes it is in the page footer.....does that make a difference? Where i put
it, is no big deal as long as it's there

fredg said:
I need just the sum of a column. I am using this =Sum([NO_DAYS]). Alls i
am getting is #error. NO_days is the correct field name... The coulmn
consists of only 1 and .5.

thanks
Click to expand...

Sum the column where? In the Page Footer?

See Microsoft Knowledgebase article:
132017 'How to sum a column of numbers in a report by page'
Click to expand...
Click to expand...
 
Top