|
I am trying to create a report which extracts column values from
non-unique records.
I need to extract name values for listing names in a report
searching for records by a fileno field which is non-unique (usually
never more than 3 records which could have the same fileno).
Using a print statement as follows:
Print <report> fileno = <colvalue>. The problem is
that now if there are two records under the same fileno, the report prints
twice, once for each name in a record under the same fileno instead one
report listing each name found.
We have tried statements like:
"Select into <var>, <tablename.colname> where
fileno = <varfileno>"
but have still been having two (or more) reports print.
Any help would be appreciated. You may reply privately if you
wish.
Thanks,
JAMES L. VAN DILLEN
Attorney at Law
1505 S. Big Bend Blvd.
St. Louis, MO. 63117
(314) 645-8008; Fax (314) 645-8016
|
