this is what the select expert is reading:
Sum (
{@Date 3}, {BILLACCT.NAME}) = 0.00 and
Sum (
{@Date 2}, {BILLACCT.NAME}) > 0.00 and
Sum (
{@Date}, {BILLACCT.NAME}) = 0.00
@Date = if ({INVOICE.DATE} in Date (2003, 01, 01) to Date (2008, 12, 31)) then 1 else 0
@Date2 = if {INVOICE.DATE} < Date (2003, 01, 01) then 1 else 0
@Date3= if {INVOICE.DATE} > Date (2008, 12, 31) then 1 else 0
I'm looking through the results that I have---and its ONLY invoices for 2002--nothing else?
IP Logged
