Search results for query: *

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

Moxy1 - It still returns every record. I ran across a note that DISTINCTROW requires at least two joined tables. - kcary

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

Can the first section also contain: From qry A INNER JOIN tbl B where the query is actually the list of records with duplicate values?

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