Multiple Parameters

[LROTA]

Hey,

in my report i have a field called number of days overdue, and am trying to essential see them sum figure of the amount which is overdue broken up between 0-30, 31-60, 61-90 and 91+

to start with i thought lets keep it simple and try to bring back any records which are overdue with a yes but it doesnt like my forumla, can anyone help?

currently i have:

IF(TOTAL DAYS OVERDUE >=0 AND(TOTAL DAYS OVERDUE <31))"YES", "NO")

But i get expected , come up and it highlights the AND

thanks,

Shane

 

[xlbo]

=IIF(Fields!TOTALDAYSOVERDUE >0 AND Fields!TOTALDAYSOVERDUE <31,"YES", "NO")


Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question