Jim, You can append "and limit = 1" to the end of the where clause of your select/print statement.
But, out of curiosity, how do you know you got the right one? Ben Petersen On 4 Feb 2003, at 1:16, Jim Van Dillen wrote: > > 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 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > >
