Re: Finding and Converting negative numbers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Take a look at the Abs function

Abs(Results) will strip off the negative signs.


"steenman2" <asteenrod@xxxxxxxxx> wrote in message
news:1149276257.417015.192550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Small problem...
I want to make all of the results of a query positive. Keep in mind
that not all of the results are negative, just a about a third of the
400.

Here is what I am talking about...

Results
.68
1.56
-.70
.23
-.34
-1.02
(Each result is affiliated with an ID number)

So I need to filter out the negative and make them positive. Should I
do this in a sub query of the one that created these results? If so
how?

Thanks for the help...



.

Relevant Pages

  • Offtopic: avoiding the web censors
    ... My school censoring software blocks oook, ... they cannot filter on domain/ip address/hostname. ... DON'T use the word 'strip' in the address! ... untenable strategy for content filtering. ...
    (rec.games.roguelike.angband)
  • Re: Formula help
    ... If the answer is correct, other than for the negative sign, then use the abs function to strip off the negative. ... John Spencer ... Access MVP 2002-2005, 2007-2008 ...
    (microsoft.public.access.gettingstarted)
  • Re: Fernandos massive sig(now off-topic but in-thread)
    ... Standardize on this format for sigs! ... Makes it easier to create a filter to strip it out of text mail... ...
    (Ubuntu)
  • Re: Savinelli balsa system
    ... cleaner through the stem and shank then put the strip back in as the ... is it really OK to leave the strip in the pipe ... I left the filter in after returning a Sav to the storage rack. ... but pull it if you intend to have the pipe rest for a while. ...
    (alt.smokers.pipes)
  • Re: OT: Re: America is the ONLY westernized country that doesnt provide any affordable health care o
    ... just goes to show what crap they make. ... One can set up a filter to strip ... out any thread with "OT" as a tag. ...
    (alt.sports.baseball.bos-redsox)