filter for fields containing same entry/data

[boofayah]

I want to filter by input, records that are identical according to field1. For example if records 1 and 2 have same identical field1=x AND records 6,7,8 have identical field1=y, but record 1 and 6 field1 aren't identical(x not equal y). After applying the filter I want records 1,2,6,7,8.

Any advice is appreciated.

 

[JerryKlmns]

So, suppose your table name is TableA then create a query with TableA and TableA (second time)

SELECT - your fields -
FROM TableA INNER JOIN TableA AS TableA_1 on (TableA.Field1=TableA_1.Field1);
[\code]

After applying the filter, change the record source from your TableA to this query.
The joinning of the TableA to itshelf on Field1, produces the result set of records that are identical according to Field1