Select if NOT Record filename Exists

[trevor-linda-weir@att.net]

It sounds to me like you need to reverse the access 
statement so you can print all of the headings from the 
I5531410 file and only the details that actually fulfill 
the linkage:

Access I5531410 link QAITM to PDITM of I4311 optional

Sort(ed) on QAITM of I5531410

Heading at QAITM of I5531410 &
  TAB x QAITM of I5531410

REPORT ....

> 
> 
> Hello List, here's one for you.
> 
> I'm using the construct for the following access line:
> 
>      Access I4311 link PDITM  to QAITM of I5531410 optional
>          Select if Not Record I5531410 exists
> 
> But what if I want a value from the from I5531410 for printing in the headings
> even
> when zero records meet the selection criteria.  This value is not presented in a
> parm anywhere but rather this I55.. file is a work file that is created by the
> user so
> it would be useful to see what the first record in the file (one that does not
> meet the
> selection criteria) looks like to validate that the correct data (most recent)
> is there.
> I could do a cover page report ahead of the main report or something like that
> but
> does anyone knows of a "slick and dirty" way or work around?
> 
> Thank you in advance.
> George
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.