Our system makes use of two datasets, one for records a year old and
older, another for newer information.

I'm trying to do a query, incorporating information from both sets.

In the first step, I'm writing data from the older set to a subfile, and
in the second, I'm using, or trying to use that subfile, when I access our
more recent data.  Unfortunately, I'm having no luck in several different
approaches, so I'm asking for any help or ideas.

This program creates the subfile, and works perfectly:

> SET REPORT LIMIT 1000000
> ACCESS ARC-DETL
> SELECT IF ARC-COMPONENT="2" AND ARC-GRADE>="E5" AND ARC-GRADE<="E8" &
> AND ARC-COURSE[3:4]="00" AND ARC-LASTTRAN[1:1]="Z"
> SORT ON ARC-SSN
> SET SUBFILE NAME ARCBOARD INDEX ARC-SSN KEEP
> REPORT SUMMARY ARC-GRADE ARC-SSN ARC-COURSE ARC-LASTTRAN


This is the start of the second program, which is not working at all.
I've tried several different permutations of the ACCESS line to no avail:

    1     SET REPORT LIMIT 100
    2     ACCESS *ARCBOARD LINK TO STUD-CRS-DETL-H AND STUD-INFO-DETL
    3     SELECT IF COMPONENT="2" AND GRADE>="E5" AND GRADE<="E8" AND &
    4     COURSE[3:4]="00" AND LASTTRAN[1:1]="Z"
    5     SORT ON SSN
    6     REPORT SSN COURSE LASTTRAN


Any help appreciated in advance.

C. Freas