Absolute Value Total (1 Viewer)

shawnacker

Registered User.
Local time
Today, 16:55
Joined
May 4, 2001
Messages
15
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
 

shawnacker

Registered User.
Local time
Today, 16:55
Joined
May 4, 2001
Messages
15
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

Registered User.
Local time
Today, 11:55
Joined
May 19, 2001
Messages
398
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).]
 

Users who are viewing this thread

Top Bottom