I think I have the thing working now; at least it's in test. Thnx to all bobh -----Original Message----- From: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mickey Grackin Sent: Wednesday, May 05, 2004 1:56 PM To: focus-l@xxxxxxxxxxxxx Subject: [focus-l] Re: TRUNCATION Try reversing the JOIN, do a JOIN B. . . TO ALL A, and TABLE FILE B instead of A. Mickey Grackin (301) 975-8417 -----Original Message----- From: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hamilton, Robert Sent: Wednesday, May 05, 2004 2:47 PM To: focus-l@xxxxxxxxxxxxx Subject: [focus-l] Re: TRUNCATION THIS IS what I get trying the join=3D20 (FOC1072) DUPLICATES IN JOIN 'FROM' FIELD : S5PG /028826090 (FOC1072) DUPLICATES IN JOIN 'FROM' FIELD : S5PG /028826090 (FOC1072) DUPLICATES IN JOIN 'FROM' FIELD : S5PG /029682557 and get one only from the A file -----Original Message----- From: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harry Wykes Sent: Wednesday, May 05, 2004 1:25 PM To: focus-l@xxxxxxxxxxxxx Subject: [focus-l] Re: TRUNCATION Micky, Greetings! SET BYDISPLAY =3D3D ON works for some versions of FOCUS PRINT .. BY ... NOPRINT works for all versions that I know of. Which is more portable? :-) >> That's the old school way of accomplishing the same result. No insult intended. :) << None taken - more of a compliment I thought. :-) Harry -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat