RE: Query/400 Question

["Alex Moore" <alexm@xxxxxxxxxxxxxxxx>]

Define your result field -> numerator / denominator + .000000001
and force the number of decimal positions to whatever you want.

Alex A. Moore ~ CIO
Ellis Hosiery Mills, Inc.
alexm@ellishosiery.com <mailto:alexm@ellishosiery.com> 
 


> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Chuck Lewis
> Sent: Tuesday, May 18, 1999 3:14 PM
> To: MIDRANGE-L@midrange.com
> Subject: Query/400 Question
> 
> 
> Hi Folks,
> 
> My boss is pretty darn handy with query (something I gave up YEARS ago;
> programs were easier <BG>) which has taken a LOAD off of me and I'm not
> complaining, what with all the OTHER stuff I'm doing right now !
> 
> Anyway, he is having a problem with a divide by 0 error and it involves
> doing a gross margin calculation so it is NOT as simple as ignoring a
> record or something. Is there ANY way to handle this in Query ?
> 
> If I've failed to provide enough useful information, let me know and
> I'll have my boss outline it :-)
> 
> Thanks !
> 
> Chuck
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---