Selection set and missing records

[GCC Consulting]

-----Original Message-----
From: GCC Consulting [mailto:gcc at optonline.net] 
Sent: Wednesday, September 29, 2004 12:13 PM
To: Filepro 2 List (filepro-list at lists.celestial.com)
Subject: Selection set and missing records

At a client's site I have a credit program (returns). My client replaced another
vendor who had similar merchandise but used different product SKU's. Some of the
products taken in are being run by my client.

When a credit is issued, if the product is a running item from my client, his
item # is added to the detail record.  Therefore, some details have just the
other vendor's sku and some have both.

Here is the problem. I ran a report twice which sub-totals on the item
description.  The first run was all of the credit details.  The second run the
selection was to select all records where the item # was empty.

I used the following selection set

 Group   Field  Heading                 Rel    Value
--------------------------------------------------------------------------------
----------

        <  13 < Item_number                <        <

--------------------------------------------------------------------------------
----------
Selector Sentence:
                                                                               <

--------------------------------------------------------------------------------
-------------
                               F6 -Display Fields
              Press  F10 -Record Selection  ESC -Cancel  F1 -Help

When I compared the full report to this report, I found that some items with no
"item #" were missing from the report.

Any ideas as to why some records were not included?

Richard Kreiss
GCC Consulting