adding values to a report

[gdzilla]

hello.

what is the expression that i would write that would add up the value from all the rows of a field in a query for a report?

example:
FIELD
1
0
1
1
1

so, what is the expression that i would enter in a text box in a report to get the sum of "4"?

thanks!

 

[zambezibill]

Add a textbox to the report or section footer and set its ControlSource to =Sum([YourFieldName])

Depending on your data, you may need to trap for null values.

Cheers, Bill