Most frequently used data in a field (1 Viewer)

[Pinkoto]

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?

 

[vbaInet]

Let's take it one step at a time, starting with your Years field.

Do you know how to build a query using the Max aggregate function?

 

[Pinkoto]

i started using access 5 days ago .. so no

 

[vbaInet]

Cool 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.

Anyway, here are some links to get you started on queries:

http://office.microsoft.com/en-gb/access-help/introduction-to-queries-HA010341786.aspx
http://office.microsoft.com/en-gb/access-help/examples-of-query-criteria-HA010066611.aspx
http://office.microsoft.com/en-gb/a...part-iii-writing-the-queries-HA010247313.aspx

 

[Pinkoto]

so i can do this in a queries only? can i do it in a form too

 

[vbaInet]

Well, you do it in a query and display that query in your form.
Queries are for aggregating or calculating data and forms are for displaying/manipulating data.