Error displayed

[dhaveedh]

I have a report which details the number of Accounts that have been actioned.

There are different action types. So my report displays Accounts that have been actioned over any particular period that may be specified by a user.

However, i want the total number of accounts that have been actioned to appear in the report. To do this i have created a textbox on the report and bound it to an expression

=Count(Accts). Accts is a field in my table which holds accounts that have been actioned. Any account appearing in that table has been actioned.

However, this returns an error on my report. Can anyone help with a better way to do this or maybe why i get an error #Error

 

[hymn]

try
sum([accts])

Hope this helps
Hymn

 

[dhaveedh]

The Accts field contains numbers and any attempt to sum them as in sum([accts]) will not give a count.

This doesnt work. Thanks anyway.

 

[CosmoKramer]

Where did you place this text box?? It should be in the report footer, not in the page footer.

Hoc nomen meum verum non est.

 

[hymn]

try below in your report footer
=Abs(Sum([accts]))

Hope this helps
Hymn