× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2005

RE: Trick math for Query 400

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 <GWenzloff@xxxxxxxxxxx>
> 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   
> 
> 
> ------------------------------

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.