Total

[Udayan]

Any one can help me please....

I have got a table with following fields

Date received = Type (date)
Item-A = Type (type number)
Item-B = Type (type number)
Item-C = Type (type number)
Item-D = Type (type number)

And i have a Report

Date Item-A Item-B Item-C Item-D
01-Jun 3 0 1 6
02-Jun 0 1 3 4
03-Jun 3 4 5 0


Is there any way to total the figures in Column Item-A, Item-B and Item-C at
the end?

Kindly help me...

 

[Allen Browne]

Try a text box with ControlSource of:
=Nz([Item-A],0) + Nz([Item-B],0) + ...

 

[Udayan]

Thanks it worked, thank u very much sir.