Hi Gang -

The issue:

Running access 2000
I have imported some records from an unfriendly application.

I wind up with records like this:

record identifier	first_name	;last_name	ins_1	ins_2
;1	;joe	;smith	;m'care
;2	;mary	;jones	;m'caid
;1	;joe	;smith	;BC/BS

How do I query the records so I

1. Have Joe reflect that he has both m'care & BS
2. Delete Joe's second record

Thanks in advance!!