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.

 

[FoFa]

Try:
Select count(1) AS fDUPS, F1, F2, F3
from Tbl1
group by F1, F2, F3
having COUNT(1) > 4