Validation Rule

[singingshiver]

I require my database to identify when the same data in 3 fields has been entered 5 times, ie when field a field b and field c have the same information in them as entered in an older record it will count them and display that value for viewing.

 

[KKilfoil]

Create a summary query from your table. Add each of the 3 fields, selecting 'Group By' as the value in the "Total" row. Add a fourth field using just about any field from your table and select "Count" in the totals group.

You can even add ">4" (no quotes) in the criteria row of the Count field above if you only want to see the results when the count is 5 or greater.