This selection is based on a higher file in the ACCESS list

[John Hunter]

Depending on what your sort is and what you want to report, the following
might work without the use of a subfile (sorry I haven't tried this):

Access *IDNUMS link to TRANSACTION-DATA opt link to SARTYPE opt

select SARTYPE  if AID of SARTYPE-DATA = "Y"

define d_SARTYPE char*4 = SARTYPE of TRANSACTION-DATA &
          if record SARTYPE exists else ' '

sort on STUDENT-IDNUM on d_SARTYPE

footing at SARTYPE STUDENT-IDNUM SARTYPE

Hope this helps,
-John
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.