If this were on a report, which I am assuming, then I would do this:

Put a text box on the report header or footer, then put this code in the text box:

What this does is Sum the Deviation values if they are less than 0, else it sums a zero.

So for this data:

Text Deviation
Row1 -1
Row2 -2
Row3 -5
Row4 6
Row5 7

The textbox returns -8.

Is that what you want?

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com