Bruce: Try this: select all from <your table> where mvplateno IN + (select mvplateno from <your table> + group by mvplateno having count(*) >1 )
Karen > After importing Excel vehicle records into a receiving table, I ran a > "SELECT DISTINCT ..." against all necessary columns in a working copy of > the receiving table. > > This revealed 'semi-distinct' records such as these: > > mvplateno mvplatestateid mvcolorid mvmfgrid mvmodel ... > (Indexed) (Indexed) > > 112 BLG CA WHT CHV MALIBU > 112 BLG CA WHT -0- -0- > 112 BLG CA -0- CHV IMPALA > 112 BLG FL -0- -0- -0- > > 123 ABC CA RED HON CIVIC > 123 ABC CA HON RED ACCORD > 123 ABC CA MAR TOY ACCORD > > I'm thinking a form-hosted, cursor-stepped editing process; producing a > list of truly distinct records keyed off the license plate number > (mvplateno). > > Where I'm hung up is how to select out only those records where > (count(mvplateno) >1). > > I'd sure appreciate a pointer in the correct use of SELECT to generate a > subset based solely on record-count. >
