Have you tried the DISTINCT option of SELECT?
----- Original Message ----- From: "Jim Van Dillen" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 11:16 PM Subject: [RBASE-L] - Extracting column values 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]>
