max.wanadoo at gmail.com
max.wanadoo at gmail.com
Fri Sep 28 11:06:14 CDT 2007
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