[AccessD] Friday (You Know)

...or times a hundred into an integer and divide by a hundred back into a
long. (The old techniques.)  Jim

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

The problem I've always had with zeroes is when a floating point error
nudges zero just a bit waaaaaay over to the right of the decimal point.
Thank goodness for current/money types.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
max.wanadoo at gmail.com
Sent: Friday, September 28, 2007 9:06 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Friday (You Know)

Wow!  Is this a candidate for your subtle bugs or what?

I never knew that and I bet not many other people did either.

Thinking about it, I actually have this problem on our Daily Cash Book
entry system - I will revisit it with this in mind.

Gosh, I learno soooo much from this list.

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, September 28, 2007 4:51 PM
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