Remove minus

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

Guest

I have a query that I am subtracting Feild1 from Field 2 I would like for
the difference to be a Whole some of my amount are negative number like -2
I would like to remove the minus sign can I do this?

Thanks
 
Is this an Excel question? If so, you should ask an Excel newsgroup, not
FrontPage.
 
See http://www.devguru.com/technologies/vbscript/quickref/abs.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I have a query that I am subtracting Feild1 from Field 2 I would like for
| the difference to be a Whole some of my amount are negative number like -2
| I would like to remove the minus sign can I do this?
|
| Thanks
 
Back
Top