[AccessD] This doesn't look right

Sounds like an argument for Access. <VBG>

Charlotte Foust

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca] 
Sent: Thursday, January 29, 2004 12:24 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] This doesn't look right


I know of an oil and gas company TransAlta in Calgary that lost $24 
million last summer due to an Excel spreadsheet error.
Ray Panko at University of Hawaii came up with a figure of 4% of all 
cells in Excel have logic errors ,without doing deep debugging or using
analysis tools. Errors are not unusual.

Charlotte Foust wrote:

>If they've been looking at bogus information all this time, it's hard 
>to tell.  "Shoot the messenger" often prevails, but if the information 
>is being used to make business decisions, would they rather make them 
>on valid information or not?
>
>Charlotte Foust
>
>-----Original Message-----
>From: Steven W. Erbach [mailto:serbach at new.rr.com]
>Sent: Thursday, January 29, 2004 9:22 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] This doesn't look right
>
>
>Charlotte,
>
>  
>
>>>HAVING includes the field being evaluated, and that has a profound
>>>effect of the results, since you're also grouping by those fields. <<
>>>      
>>>
>
>Very succinctly explained. Thank you. This could wind up to be 
>embarrassing since this app has been in operation for some time using 
>the original developer's code. I just took it over at the beginning of 
>the month. Will I be a savior or a stooge? The question of the day...
>
>Regards,
> 
>Steve Erbach
>Scientific Marketing
>Neenah, WI
>920-969-0504
>
>Message created with Bloomba
> 
>Disclaimer: No tree was killed in the transmission of this message. 
>However, several coulombs of electrons were temporarily inconvenienced.
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com 
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com