Hi
I'm using MS Access 2002 / VBA 6.
I've a database with several tables / forms, and some code. Everything is working fine.
I have 2 fields in each form. Each of these fields contain names from employees.
What I need to find among all these form's 2 fields, is the most common name (the one that appears the most) in both 2 fields together.
Some of the fields may be empty.
I need to perform this with a button, and I would also like that the search would be made in ALL forms, which means that by clicking the button only one name would come as output (msgbox maybe).
Structure Example:
Form1 Form2 Form3
name1 name1 name1
name2 name2 name2
Data Example:
Form1 Form2 Form3
Anthony Tom
Tom Andrew
Out of the example above, Tom would come as output.
Please Help
Access / VB Newbie
Thanks