Absolute Value Total

[shawnacker]

I have a table with a a column that contains both positive and negative values. I also have a query which totals these values. I would like for my query to return the absolute value total instead of an aggregate total. Do I need to create a separate table just to do this or can I input some sort of expression in the query which can accomplish my goal?

Thanks in advance,

Shawn

 

[Rich]

>0 in the criteria grid?

 

[shawnacker]

The only thing that does is give the positive amounts. I want all amounts, both the positive and negative totals (whichever it may be).

 

[pcs]

add a field to your query and use the builder to create this expression:

Abs([yourfield])

you can then sum this field...

hth,
al


[This message has been edited by pcs (edited 08-04-2001).]

 

[shawnacker]

Thank you. That worked perfectly!