Doing the Math

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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
 
Back
Top