Quick Report Using NOT LOOKUP Filter
          Scenario: The Dean  of Students  has asked  for a  list of  full-time
          students and their phone numbers who do not live in a dormitory.  The
          list must be  in order  by the  last name  and grouped  by the  phone
          number area code.
          Solution: Create a Quick Report that selects only  students from  the
          STUDENT file whose status is full-time and who are not listed in  the
          DORM file. Group the report by the first five characters of the phone
          number (which is  the area  code). The  DORM and  STUDENT files  both
          contain the student's Social Security number so that is the link used
          to compare the two files. 
               Open the DORM and the STUDENT file.
               Select Quick Report from the Data menu.
               Fill in the Quick Report areas as shown below.
          Columns
               LastName.STUDENT
               FirstName.STUDENT
               MI.STUDENT
               HomePhone.STUDENT

          Select the Distinct box below the Columns listing. 

          Groups
               Select Calculate and enter "Area Code" in the As: block
               Enter the Formula: LEFT$ ( HomePhone.STUDENT , 5 )

          Filter
               NOT ( LOOKUP ( SSNum..STUDENT, SSNum.DORM)) AND 
                Status_FP.STUDENT = "F"

          Order
               LastName.STUDENT
               FirstName.STUDENT

          Header
               Enter the report Header text, "Full-Time Students Not Living on
     Campus" and 
               select Include date and Include page number.
               Select Save and name the report file, "STUFTND.sbq"
               To run the report, select  your desired  Destination then  press
               OK.
     Manual references

     Working with Data, pg. 8-1, "Creating quick reports";  Working with  Data,
     pg.  5-2,  "Using  the filter  dialog box";  Working with  Data, pg.  5-7,
     "Formula box"; Working with  Data, pg.  5-8, "Writing  a filter";  Working
     with Data, pg. 5-14, "Logical operators"
















Program:  Superbase 
Versions: 2.0
Date:     April 8, 1994       
D
Date: