help with expression

[Ryon]

I need to work out a experession for a report, I need it to give the sum of the TOTALS column where the COMPDATE is between 0 to 30 days old. the TOTALS field and the COMPDATE are in the details section, and I was going to create a text box and put it in Control Source. Is this how I should do it?

Thanks AGAIN!!

Ryan

 

[mp9]

You might try a text box with something like

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

in it. The ([COMPDATE] Between 0 And 30) evaluates to true (-1) or false (0), so this can be used to multiply against the value in [TOTALS] - if the [COMPDATE] value isn't is range [TOTALS] gets multiplied by 0 and so has no effect on your sum. You need the * -1 on the end to make up for the fact that True evaluates to -1, not 1.

HTH.

http://www22.brinkster.com/accessory/

 

[Ryon]

I tried that but all I get is a zero in the text box, I dont see where your expression references between now and and the previous 30 days. could you also explain to me why we multiply the sum of the totals column by the date.thanks for your time!!