# error of text box when summing a total of column in access 2007

[falahsalih]

Hi all,


I have a sub report .I'm trying to sum a column values and put the result in a text box. In the control source of the text box m I'm using the following expression

=Sum ([total])

, where total is the name of the column that i want to sum it up. The problem is the result of the text box is

# error

any help please ?
many thanks.

[burrina]

Do any of the controls possible have Null values? Try using the Nz function for those controls. Example:

Nz([ID],0)

HTH

[falahsalih]

Do any of the controls possible have Null values? Try using the Nz function for those controls. Example:
Burrina,
HTH

Can you help me how to use Nz function please ?

[burrina]

Here is an Example on a Report: You could also simply use the Nz function in your Reports Data Source,i.e. Query.

Order Totals: Nz([Line Item Totals])+Nz([Taxes])+Nz([FreightCharge])

=Nz(Sum([Payment]),0)

HTH