Doing the Math

U

UT Lab Sup

I would like to be able to set a Column in one of my queries that will give
me the abs(max() of a series of columns within the query .. I am having
trouble.. I can seem to get the column within the query to do anything
except either add or sub the columns with in the query....
 
T

Tom Ellison

Dear Sup:

First, do you want the abx(max()) of the value, or the max(abs()) of the
value? Consider:

-1 5 -8

The abs(max()) would be 5, the max(abs()) would be 8.

Next, is your query already a totals query, grouped on the set of values on
which you want to do this? If you would post a bit more detail, perhaps
some sample data and the desired result, along with the SQL you have so far,
I believe I may be able to help more.

Tom Ellison
 
Top