[AccessD] Friday (You Know)

Well, zero is still zero, but if you work with a signed integer, it is
possible to have the sign as negative, and the value as zero. In doing a
comparison,  the process sees that as unequal, even though the value is
technically the same.

My boss loves to tell his 'negative zero' story....it would take 3 pages
to share, so I'll spare ya'll the boredom! ;)

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, September 28, 2007 10:51 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Friday (You Know)

Actually that was one of my first columns. It had this message box that
said
"The balance is not zero. The balance is 0.00". It all came about
because if
you put in a credit (minus) value first, the result would be minus zero.
Simple enough to fix with ABS(), but until then I didn't realize that
there
were two values for zero.

Arthur

On 9/28/07, Drew Wutka <DWUTKA at marlow.com> wrote:
>
> How about one that misses a negative zero?  (obviously not an issue in
> VB or VBA)
>
> Drew
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.