Posted by paulmac106 on 03/07/07 16:59

I think it's simple, but I can't get it to work.

In English its: find records in TableA where the field [Field1] has
more than one unique value in Field2

sample records in TableA

Field1 Field2
2241 12345
2241 12345
2242 12345
2242 99856

desired return (2 records)
2242 12345
2242 99856

thank you for your help

Paul

[Back to original message]