Hi, Bill
Would you like to use new windows style tools ?

My Answer for
1. Use schema editor from Minisoft to redefined data source
as you like to see.
2. ODBC/32 with Access 97 link table with IMAGE or
Query Save file(SDF) and run MS access query to group with
or select disctinct by group-field and print or copy paste to
some PC type file like Excel...

 with HP3000 query ???

Frankly, HP3000 side do not have fast extraction tool..
Since open connection via TCP/IP use tool from MicroSoft
or Minisoft you can extract faster ...
Peter C.
Sr. Systems Analyst

Bill Lancaster <[log in to unmask]> wrote in message
news:F4B1826B1A21D211AEC5006008207AF4011F309F@dogbert.csillc.com...
> Hi all,
>
> It's been many years since I've been forced to use Query to do extensive
> data extraction but am now in that position.  Unfortunately, I don't
> remember how to do it.
>
> What I'm trying to do two things:
>
> 1.  Extract subfields out of a STR40 item (e.g. 30:3 and 1:12) and don't
> want the whole item.
>
> 2.  Don't extract duplicate records.
>
> Any thoughts?
>
> TIA,
>
> Bill
>