Prev: Microsoft Office Spreadsheet 10.0
Next: Microsoft Office Spreadsheet 10.0
From: zyus on 21 Apr 2010 00:44
I used this expression in my text box in report

=(Abs(Sum(([mthtag]="Current Month" And [ACCTSTAT]="Current")*[NET_BAL])))

How to use sort of the same expression of the above but to display text data
only. I tried to use this expression but failed

=([mthtag]="Current Month" And [ACCTSTAT]="Current")*[Branch]

Thanks
From: RonaldoOneNil on 21 Apr 2010 06:10
=IIf([mthtag]="Current Month" And [ACCTSTAT]="Current",[Branch],"")

"zyus" wrote:

> I used this expression in my text box in report
>
> =(Abs(Sum(([mthtag]="Current Month" And [ACCTSTAT]="Current")*[NET_BAL])))
>
> How to use sort of the same expression of the above but to display text data
> only. I tried to use this expression but failed
>
> =([mthtag]="Current Month" And [ACCTSTAT]="Current")*[Branch]
>
> Thanks
 | 
Pages: 1
Prev: Microsoft Office Spreadsheet 10.0
Next: Microsoft Office Spreadsheet 10.0