Certainly, the Abs() function is Absolute Value. If the user enters a

negative number (knowing that you're wanting a negative number), such as -2,

then (-2)*(-1) is 2, a positive number. However, the poster wants to always

store a negative value. The absolute value function will always give a

positive number (or zero, of course), so that when you multiply by -1, the

value will be negative.

Abs(-2) is 2

Abs(2) is 2

2*(-1) is -2

--

Wayne Morgan

Microsoft Access MVP

"Mark" <ma**********@ntlworld.com> wrote in message

news:7J***********@newsfe5-gui.ntli.net...

Hi Wayne,

could you explain what the 'Abs' is doing?