Have the following setup:
TABLE1 (Has only 3 fields)

Field Name Type Length

Class Text 14
Arrive Date
Depart Date

This table can have multiple records for same class. What I'm wanting to do is print a report that displays one record for each class that includes Class Name ,Earliest Arrival Date, Latest Departure Date.

Example:

Art 101 Art 101 Art 101
07/17/2008 07/16/2008 07/16/2008
08/21/2008 08/22/2008 08/21/2008

When I run the report would print:

CLASS NAME Earliest Arrival Latest Departure

Art 101 07/16/2008 08/22/2008

If the date variables are offset dates (a/k/a smart dates), Focus will order the dates properly, and

WRITE
MIN.ARRIVE_DATE AS 'Earliest Arrival'
MAX.DEPART_DATE AS 'Latest Departure'
BY CLASS_TEXT AS 'CLASS NAME'

should work just fine.

If not, use DEFINE to derive offset date variables.