Notices
The Basement Non-Honda/Acura discussion. Content should be tasteful and "primetime" safe.

access/excel help

Thread Tools
 
Old Jul 29, 2005 | 10:57 AM
  #1  
Grifter's Avatar
Grifter
Thread Starter
Senior Member
 
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Default 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
Reply
Old Jul 29, 2005 | 10:57 AM
  #2  
DakarM's Avatar
DakarM
 
Joined: Oct 2000
Posts: 44,908
Likes: 0
From: Location Location
Default

get to work lazy bones!
__________________
'00 Dakar Bus CRS Edition
LCD Squad #0001
Originally Posted by WiLL
...I really wanna get out and shoot people.
Reply
Old Jul 29, 2005 | 10:57 AM
  #3  
Grifter's Avatar
Grifter
Thread Starter
Senior Member
 
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Default

derailment/idiocy
Reply
Old Jul 29, 2005 | 11:00 AM
  #4  
westcoaststyle's Avatar
westcoaststyle
Still here... sorta...
 
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Default

select distinct if you want to hide them in a query

Any chance you can send me the file?
Reply
Old Jul 29, 2005 | 11:01 AM
  #5  
e3NiNe's Avatar
e3NiNe
#CustomUserTitle
 
Joined: Mar 2002
Posts: 63,855
Likes: 1
From: glass case of emotion
Default

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:
Reply
Old Jul 29, 2005 | 11:03 AM
  #6  
westcoaststyle's Avatar
westcoaststyle
Still here... sorta...
 
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Default

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:
Reply
Old Jul 29, 2005 | 11:04 AM
  #7  
Grifter's Avatar
Grifter
Thread Starter
Senior Member
 
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Default

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
Reply
Old Jul 29, 2005 | 11:10 AM
  #8  
westcoaststyle's Avatar
westcoaststyle
Still here... sorta...
 
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Default

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?
Reply
Old Jul 29, 2005 | 11:14 AM
  #9  
Grifter's Avatar
Grifter
Thread Starter
Senior Member
 
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Default

what i email to you a sample?
its excel
Reply
Old Jul 29, 2005 | 11:17 AM
  #10  
westcoaststyle's Avatar
westcoaststyle
Still here... sorta...
 
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Default

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.
Reply



All times are GMT -8. The time now is 01:17 AM.