RE: IIf comparison

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Trevor Mills <TrevorMills@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 23 Jun 2005 07:39:04 -0700

Qreate a query with the following equation

Expr1: Abs(Abs([Field1])-Abs([Field2]))

"Kim" wrote:

> I need to write an iif statement (or something else?) that will show a result
> where if the first field is greater in value than the second field, it will
> subtract the first from the second. But if the first field is less in value
> than the second field, I need to reverse the equation to avoid negative
> results. Example -2,000 in first field minus 70,000 in the second field.
> Needing the result to be 68,000.
>
> Thanks
.

Follow-Ups:
- RE: IIf comparison
  - From: Kim

References:
- IIf comparison
  - From: Kim

Prev by Date: Re: Totals on Same Page
Next by Date: Re: two copies of same report on 1 page
Previous by thread: IIf comparison
Next by thread: RE: IIf comparison
Index(es):
- Date
- Thread

Relevant Pages

RE: IIf comparison
... Make the subject as explicit and descriptive as possible. ... "Kim" wrote: ... >>> where if the first field is greater in value than the second field, ... But if the first field is less in value ...
(microsoft.public.access.reports)
Re: dpkg -l postfix
... Every field of this tabular output has a caption. ... The first field is set to "i", so according to the caption, the desired ... action that dpkg sees for this package is "Install". ... The second field is set to "i", which means the current status is ...
(Ubuntu)
RE: IIf comparison
... "Trevor Mills" wrote: ... >> I need to write an iif statement that will show a result ... >> where if the first field is greater in value than the second field, ... But if the first field is less in value ...
(microsoft.public.access.reports)
Re: Question on how relationships work
... Bill, you say "the user does not even see the first field ... ... I have a value list for a drop down field, with OrgID as first value, and OrgName as second value, with only OrgName visible - so far so good. ... I gave you an answer in your other thread, suggesting that you use a drop-down list, with the Person ID number being the first field, and the calculated NameLastFirstSuffix as the second field and the only field visible to the user. ...
(comp.databases.filemaker)
Re: Question on how relationships work
... The user does not even see the first field that is ... and the second field is sorted alphbetically. ... You seem determined to avoid this approach as being too cumbersome. ... visible field. ...
(comp.databases.filemaker)