|
Vernon, I changed the way that I was calculating the total that I was looking for so that I could use the data from a different field in the file and avoid the problem of mismatched signs in my original calculation. Thanks, -doug -----Original Message----- From: Vernon Hamberg [mailto:vhamberg@attbi.com] Sent: Friday, March 22, 2002 4:03 PM To: midrange-l@midrange.com Subject: RE: query and absolute value What did you do, if you don't mind? At 04:03 PM 3/22/02 -0600, you wrote: >Thanks for the info, I finally figured out a different way to get what I >need. > >-doug > >-----Original Message----- >From: Vernon Hamberg [mailto:vhamberg@attbi.com] >Sent: Friday, March 22, 2002 3:13 PM >To: midrange-l@midrange.com >Subject: Re: query and absolute value > >Not that I know of. The DIGITS function will ignore the sign, but it >creates a character string. No way to convert back. >
As an Amazon Associate we earn from qualifying purchases.
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.