Remove Minus

[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

 

[Al Campagna]

Octet,
Check out the Abs (Absolute) function in help.
Abs(-10) = 10
Abs(10) = 10
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."