DUPLICATE RECORDS

[Yolevich, Jim]

Add a counter to your subfile and make another pass on it subtotalling your
counter into the next subfile. If you're trying to find duplicate vendor
numbers, sort on vendor number and build your next subfile at vendor number
with a subt on your counter.  Otherwise, do it at vendor name.  Then select
the records where your counter is > 1.

ACCESS VENDMAS
DEFINE CNT NUM = 1
SET SUBFILE NAME SUB1
REPO SUMM VENDOR-NO NAME ADDR1 ADDR2 ZIP CNT
GO
ACCESS *SUB1
SORT ON VENDOR-NO
SET SUBFILE NAME SUB2 AT VENDOR-NO
REPO SUMM VENDOR-NO NAME ADDR1 ADDR2 ZIP CNT SUBT RESET AT VENDOR-NO
GO
ACCESS *SUB3
SELECT IF CNT > 1
...

Hope this helps.

Jim Yolevich
Renaissance Publishing Co., Inc.
Auburn, IN

-----Original Message-----
From: Arnone, Anthony [mailto:aarnone@grey.com]
Sent: Thursday, July 15, 1999 11:46 AM
To: 'POWERH-L@LISTS.SWAU.EDU'
Subject: DUPLICATE RECORDS


Hello everyone,

	I have a problem that I cant seem to figure out. I'm running 8.19 on
an hp3000, and i have a file that has:
  
 VENDOR-NO	NAME 	ADDR1	ADDR2	ZIP

I need to create a report of duplicate vendors, the problem is that the
vendor-no's are different but the vendor names are duplicated:

12345		federal express
99990		federal express
00045		federal express

Any help would be appreciatted. 

		R/S
		Anthony

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.