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

>0 in the criteria grid?

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

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).]

Thank you. That worked perfectly!