So this is a very basic question, listen up:
I have only one table in my database. The table contains several text fields ( about 8 ).
The table is filled with very very much data. The problem is that i have a multiple
instances of the same data ( i mean apsolutly same, all the fields are same ) so
i need to delete copies.
Help please. Those copies are making me mad
Last edited by ElastoManiac; 12-02-2005 at 03:06 PM.
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
Here's something similar I did for a table of mine that had a bunch of drawings in it. There's a wizard for this in there, too (which is where this was generated from)
SELECT Drawings.Dwg_Num, Drawings.Station, Drawings.Title
FROM Drawings
WHERE (((Drawings.Dwg_Num) In (SELECT [Dwg_Num] FROM [Drawings] As Tmp GROUP BY [Dwg_Num] HAVING Count(*)>1 )))
ORDER BY Drawings.Dwg_Num;
-Govtcheez
[email protected]
Is this some kind of VB macro, 'cause i don't know VB neither do macros.
How to use wizard?
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
That's SQL. Open a query and go to SQL view by right clicking on the form.
The "Duplicates" wizard should be in one of your menus.
EntropySink. You know you have to click it.
If you don't know SQL, it's pretty tough to get too far in MS Access. Access's help section has some info about it, but it's very, very bad. Search online for a tutorial.
Sent from my iPad®
This is not a complicated database, it's a single table for god's sake, why should i learn SQL?
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
Oh I didn't know you were just gonna keel over and give up on life after this database. I just thought you might want some information for the future.
Nevermind, though. Don't mind me.
Sent from my iPad®
I have done everything you'v told, except the last thing, i can't find the wizard in any menu.Originally Posted by ober
Does it matters if my Access is a bit old ( 2000 version )
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
sorry for that
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
The find duplicates query only finds duplicates, it doesn't delete them. Unfortunately there isn't an easy way to get rid of them that I know of unless you know SQL.
What I usually do is copy the table, then paste but only paste the structure (it should ask). Then in this new table set the fewest amount as columns that you can as the primary keys but that will not completely delete unique rows. Let me know if this is confusing and I'll clarify. Then simply append the original table to this new table, it'll say something like appending XXX items but could not append YYY items due to key constraints. Click OK and your new table shouldn't have any duplicates.
Ok, heres what i will do. Since i obviosly don't know how to do this, could someone remove the duplicates for me?
Just give me your e-mail, and send back the database with no duplicates.
i'l send the database with duplicates - the database is about 1,2 MB
// this is not rule breaking since this doesn't have to do anything with programming...
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
You could try this. I'm sure you can figure out how to execute an SQL statement.
Code:SELECT DISTINCT * INTO [NewTableName] FROM [OldTableName]
I have found the wizard!!!
No need to help anymore...
But i really wish to learn SQL, so if anyone has a link to tutorial of somekind...
lu lu lu I've got some apples lu lu lu You've got some too lu lu lu Let's make some applesauce Take off our clothes and lu lu lu
search google... you'll find literally thousands of tutorials.
EntropySink. You know you have to click it.
