Select if NOT Record filename Exists
george.j.wen@us.abb.com
george.j.wen@us.abb.com
Fri, 14 Dec 2001 12:46:34 -0600
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