sum criteria problem!

[Ryon]

I have a statement report that I'm trying to get the sum of the TOTAL column WHERE the COMPDATE is between DATE()-30 and date-60.
I have tried the expression below but all I get is ERROR.

=Sum([DUE]*([COMPDATE] Between 0 And 30)*-1)

I have also tried to do it with the DSUM function and get the same results.

Text64 = DSum(&quot;[DUE]&quot;, &quot;qrybilling_statement&quot;, &quot;[compdate]<date()-30 and > data()-60&quot

anybody have any ideas, this is the last piece I need to complete my project. there has to be an easy way to do this

thanks again,
Ryan

 

[scriverb]

Try this:

Text64 = DSum(&quot;[DUE]&quot;, &quot;qrybilling_statement&quot;, &quot;[compdate] < date()-30 and [compdate] > data()-60&quot


Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???