RE: Trick math for Query 400

Although this is very elegant, this topic is a good case (heh) for using QMQRY 
instead of Query/400. QMQRY is simply an SQL statement, and those have all the 
conditional stuff you want for this kind of thing, using the CASE clause.

Vern

-------------- Original message -------------- 

> Bob Ellsworth has an Sep. 1, 2000 TechTalk article at MC Press Online called 
> "Query/400 Finds the Larger of Two Numbers" that should help. 
> 
> The link is: 
> http://www.mcpressonline.com/mc?50@xxxxxxxxxxxxxxxxx@.214a2ac9 
> 
> 
> > ------------------------------ 
> > 
> > message: 7 
> > date: Thu, 27 Jan 2005 10:20:26 -0500 
> > from: Greg Wenzloff 
> > subject: Trick math for Query 400 
> > 
> > I need a simple report to come out of Query but one column must not go 
> > negative. In the define results screen this field is 
> > defined as a simple 
> > C = A - B but we do not want C to be negative. We would like 
> > to have a zero 
> > instead. A and B are both 7 digit numbers with no decimals. 
> > 
> > Is there any trick math that would do this? 
> > 
> > Thanks, 
> > Greg 
> > 
> > 
> > ------------------------------ 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>