I'm still new to Access, and I haven't verified this, so 'your mileage may vary'. Add another field to the query with Table = tablename, Field = Name, then click the backwards E in the menu bar. A line labeled 'Total' should appear in the query... For that field you just added, change "Group...
You, sir, are a genius! Well, almost. One more step to go (I think). I've implented the query to add the Count field. From there, I've added another query to check the one above for count>1, which provides a list of items with multiple records and at least 1 which doesn't match the others...
From the top:
I have an unnormalized table. The table contains 42 fields and >3000 records. This table contains items that our company sells, and is precisely the style of flat file which drove the creation of relational databases. For example, we may have 5 records for one item - each...
I spoke too soon, maybe. I went back, changed the MakeTable to a Select query, then used the second query to query the first... It was then that I ran into a dilemma. One of the fields I left out of the query was part of the PK for the main table... rendering my query "not updateable".
Is...
Thanks, Moxy1 and JonFer!
I was able to put everything together at last. The trick was to make two queries. The first, a MakeTable using DISTINCT, created a table which still included a single record for the the items I wanted to have removed. In the second query, I used MS's standard...
I tried this starting at the query level and haven't had lotsa luck. What I'm using now is a maketable qry which leaves me with a table containing duplicate records.
I'd like to filter out the records where ALL fields match any other record in the table. Like this:
F1 F2 F3 F4...
I'm going to try to answer two posts at once here.
lespaul - The live table is 4057 records w/ 42 fields (a few are text/memo for good measure). This scanning of duplicates happens 2-3 times per day, so I don't know if the wait can be justified. I'll let it sit overnight to ensure that it...
Running the SELECT DISTINCT query against a copy of the live database took >15 minutes to reach 100% and wasn't responsive after reaching 100%.
I don't see a change. I'm using a table very much like the example I cited above:
Field1 Field2 Field3 Field4
a b c d
a b c d
x b c d
x b c x
x b c...
I'm using the standard 'In(Select...' to find records with duplicate field values. Now that I have the list, I'd like to view only those where all fields in the duplicate records are not equal.
For instance:
a b c d - will show
a b c x
a b c d - will not show
a b c d
I've tried...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.