access/excel help
Jul 29, 2005 | 10:57 AM
Thread Starter
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
access/excel help
lets say i have a some duplicate rows. how do i remove the duplicates for good and not just filter them out?
its about 5000 rows
Jul 29, 2005 | 10:57 AM
Joined: Oct 2000
Posts: 44,908
Likes: 0
From: Location Location
get to work lazy bones!
__________________
'00 Dakar Bus CRS Edition
LCD Squad #0001
Quote:
Originally Posted by WiLL
...I really wanna get out and shoot people.
Jul 29, 2005 | 10:57 AM
Thread Starter
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Jul 29, 2005 | 11:00 AM
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
select distinct if you want to hide them in a query
Any chance you can send me the file?
Jul 29, 2005 | 11:01 AM
Joined: Mar 2002
Posts: 63,855
Likes: 1
From: glass case of emotion
Quote:
Originally Posted by westcoaststyle
Any chance you can send me the file?
violation of company privacy policy
I think that's 5 warning points
h:
Jul 29, 2005 | 11:03 AM
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Quote:
Originally Posted by e3NiNe
violation of company privacy policy
I think that's 5 warning points
h:
5.5... it's pretty harsh. And they stick for 45 days
hnoes:
Jul 29, 2005 | 11:04 AM
Thread Starter
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Quote:
Originally Posted by westcoaststyle
select distinct if you want to hide them in a query
Any chance you can send me the file?
i dont want to hide them, i want them deleted
and if i send you this file i might go to jail forever
Jul 29, 2005 | 11:10 AM
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
send it, you live on the edge... you know it.
h:
Who will know? Come on, Chuck... everyone's doing it.
:chuckles:
Can you give me an example of one of the duplicate rows? Is this excel or access?
Jul 29, 2005 | 11:14 AM
Thread Starter
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
what i email to you a sample?
its excel
Jul 29, 2005 | 11:17 AM
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Quote:
Originally Posted by DakarM
they do a Super job. i think that's why it says Super Cuts on their sign
h:
n/m
Last edited by westcoaststyle; Jul 29, 2005 at 11:21 AM .