I do not want to delete the duplicates. The steps are,
1.
I am putting the circnum and circdescr fields together into the circuit field
2.
In data sheet view the engineer copies down a group of records.
He then changes either the circnum or circdescr field. which in turn updates
the curcuit field.
2.
I want to be able to filter by duplicates so that they can see if they
missed changing any of the items.
3.
I do not let them exit the form until they have fixed all duplicates.
"Ron Weiner" wrote:
> Cynthia
>
> Why not delete the duplicates for em automagically? Here is a simple
> example deleting duplicate rows in a table. You may have to use a more
> complex
>
> DELETE * from SomeTable WHERE ColPriKey = (SELECT Max(ColPriKey) AS
> RowToDelete FROM SomeTable GROUP BY ColWithDupes HAVING Count (ColWithDupes)
> > 1)
>
> Might have to re-run the query several times to get rid of dups when there
> are more than two duplicate rows. This query only delete one row (the Max
> Primary key) of all duplicate rows each time it is run. If you had 4
> duplicate rows of one item you would have to run this query 3 times to kill
> all of the dupes.
>
> --
> Ron W
> www.WorksRite.com
> "Cynthia" <(E-Mail Removed)> wrote in message
> news:3410F5C0-9326-4750-80AD-(E-Mail Removed)...
> > I have a form that the users copy multiple items in datasheet view.
> > When finished I do not let them exit untill they have fixed duplicates.
> >
> > They want to filter for the duplicates on the form then fix them.
> > When I change my me.recordsource to a qry that gets a count of the records
> > and change the me.filter where count > 1 my record is not updateable. Is
> > there
> > another way to go about this?
> >
> > Appreaciate any help.
>
>
>
Similar Threads
