How can i see the most frequently used data in a field?
For example if i have years put in a field, how can i see what is the most frequently used year and also how many times it's used? It will be a plus if i can see all the years in order.
Also if i have one field and in that field i have more than one name, can i find again which is the most frequently used name?
For example if i have years put in a field, how can i see what is the most frequently used year and also how many times it's used? It will be a plus if i can see all the years in order.
Also if i have one field and in that field i have more than one name, can i find again which is the most frequently used name?
.. so no 
You probably don't know enough to accomplish what you're trying to achieve and I'm not even sure you've created your tables properly. To be honest, you need to first understand how tables work before you delve into this stuff.
