Finding for non-zero numbers

#1

This should be simple; I'm probably just an idiot...

I am scripting a report that shows everyone who owes us money and everyone
to whom we owe money. This is a simple find against an AMOUNT DUE field. But
I'm unable to streamline the find request to show every record whose field
is NOT ZERO. Is there no easy way to do this??

- There is no NOT EQUAL symbol
- I tried an OR request
- I shouldn't have to script a methodical journey through the find process,
but will if I have to.

What am I missing...?

#2

Rick Altman <rick.a (AT) NOSPAMaltman (DOT) com> wrote:

Quote:

I am scripting a report that shows everyone who owes us money and everyone
to whom we owe money. This is a simple find against an AMOUNT DUE field. But
I'm unable to streamline the find request to show every record whose field
is NOT ZERO. Is there no easy way to do this??

- There is no NOT EQUAL symbol
- I tried an OR request
- I shouldn't have to script a methodical journey through the find process,
but will if I have to.

You might search for zeroes and then show omitted records.

Or:
Enter search mode
Enter >0 in the amount due field
Create new query
Enter <0 in the amount due field
Search

--
http://clk.ch

#3

Or do your find requests, then add a last find request that is '0' and
mark the Omit checkbox (which can be done in a script with the Imit
Record step).

Christoph Kaufmann wrote:

Quote:

Rick Altman <rick.a (AT) NOSPAMaltman (DOT) com> wrote:

I am scripting a report that shows everyone who owes us money and everyone
to whom we owe money. This is a simple find against an AMOUNT DUE field. But
I'm unable to streamline the find request to show every record whose field
is NOT ZERO. Is there no easy way to do this??

- There is no NOT EQUAL symbol
- I tried an OR request
- I shouldn't have to script a methodical journey through the find process,
but will if I have to.

You might search for zeroes and then show omitted records.

Or:
Enter search mode
Enter >0 in the amount due field
Create new query
Enter <0 in the amount due field
Search

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Finding for non-zero numbers

comp.databases.filemaker comp.databases.filemaker

Finding for non-zero numbers - 11-02-2005 , 02:57 PM

Re: Finding for non-zero numbers - 11-02-2005 , 03:39 PM

Re: Finding for non-zero numbers - 11-02-2005 , 04:10 PM