Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
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 mailing list archive is Copyright 1997-2026 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.
midrange.com
