To Anyone?

Consider a REGISTERED STDNT TERM TABLE (MFD). TABLE that contains mulitple Term Records for ea StdntID. A WF REPORT DISPLAYS EA TERM RECORD by ea STUDENT ID for 4 Terms (most current term, descending). Additionally this record details needs to reduce, filter and display only a specific detail record. So that only a Student with 1 specific Term record is displayed. Or stated another way, if a student has more than one term record, that STDNT ID# will not be displayed else the record will be displayed. Only a STUDENT ID with one TERM will be displayed.

Any guidance/assistance/direction would be appreciated.

Thanks

Mike

This message has been edited. Last edited by: Kerry,

You might be able to use a multi-verb request, where the first part of the request counts the number of records and the second part displays those records meeting the count criteria. Here is an example using the CAR file.

TABLE FILE CAR
 COUNT CAR
 BY COUNTRY
 PRINT
  CAR
  MODEL
  SEATS
 BY COUNTRY
 WHERE TOTAL CNT.CAR EQ 1 ;
END