Text Box In Report

Z

zyus

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Variance In Crosstab 2
Query with negative values 10
sum not tally 2
Hello happy new year to all, Text box input for year of purchase 0
Current user 3
DAvg function w/ date criteria ? 2
Access Access Report Works on One Machine but not Another 3
Help with an IIF expression 2

Top