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 table. Each of these fields contain names from employees.
What I need to find among all these 2 fields, is the most common name (the one that appears the most) in both 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 of the database (all the tables), which means that by clicking the button only one name would come as output (msgbox maybe).
Please help.
4  1908 
...I've a database with several tables / forms, and some code. Everything is working fine.
I have 2 fields in each table. Each of these fields contain names from employees.
What I need to find among all these 2 fields, is the most common name (the one that appears the most) in both fields together.
Some of the fields may be empty.
...
Hi daoxx. I am sure the moderators wil advise you that posting multiple threads on the same topic is not an appropriate thing to do. Is this a student assignment that you are undertaking? If it is, you will see from the site rules that we cannot simply do the assignment for you, nor would it be fair to ask us to.
You need to do some research for yourself on how best to process your records - it is up to you whether you use SQL or VBA to do so. With a bit of ingenuity you could use Count queries in SQL to give you counts of the number of separate forenames and surnames, and I am sure you will find you gain much more understanding of what you are doing if you find it out for yourself.
-Stewart
Thanks for the fast response.
I felt ignored on the other thread, and I'm sorry for double-posting the thread.
This isn't "homework", it's for my part-time job. Please help me.
Also, I do not seek experience with Access-related subjects.
I need this done, and nothing more.
Please help me.
Thanks for the fast response.
I felt ignored on the other thread, and I'm sorry for double-posting the thread.
This isn't "homework", it's for my part-time job. Please help me.
Also, I do not seek experience with Access-related subjects.
I need this done, and nothing more.
Please help me.
Hi daoxx. I have pointed you in one particular direction, and I would strongly suggest you develop Count queries for your tables. With limited Access experience, which from your reply you are not keen to develop, then going the VB route is simply not practicable. Use Access queries developed using the query designer or from SQL outlines such as the one below, tailored to meet your needs.
The general form of the Count query is - Select [name field], Count([name field]) As [How Many] from [your table]
-
GROUP BY [name field]
-
ORDER BY Count([name field];
-
Regarding your 'all tables' requirement - depending on how many there are it may be simpler and much quicker that you devise similar count queries for all your tables, run them, then aggregate the results using Excel, say, which is excellent at such number crunching tasks.
-Stewart
Thank you. (Needs at least 20 characters.)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: John |
last post by:
Hi everyone !
This is a first time I post a message here. If I post my message in a
wrong group. Please ignore it.
I am trying to build a website which allows users (can be thousands of
users, supposedly) to upload their files to their designaged
directories (max 15 files for each user). A super user (can be more
than one) want to search for a particular file name and also a
particular textual part of a file of all user's files in all...
|
by: donald |
last post by:
Hi all, I have a website running asp (about to move to asp.net soon though)
which has a list of DVD's I have the various pages I want, last 10, listing,
full listing ect, but the one page i can't figure out is a search page.
I have read various books, but none have given any tips on how to make a
search page for a access DB.
Could someone point me to a tutorial?
Thanks
|
by: sal achhala |
last post by:
I'm working with java and XML documents in order to search for keywords in a
given element name, eg element name 'author' == "jo blogs".
The problem is the XML documents are downloaded (this process is automated)
from different websites thus the element names for author may differ!
Is their a way of dealing with this, such as perhaps a standard adopted by,
say educational websites to agree on element names ?
Thanks very much
|
by: Nash Kabbara |
last post by:
Hi all,
I just finished writing a log reader that reads xml logs (about 1 to 2 MB
large). At the command line you can specify the file name, the name of the
element and it's value like so: logreader log.txt MyElement myvalue
In retrospect, I've noticed that it takes a long time to process. The time
is spent on comparing the value of all tags named MyElement to myvalue.
Namely:
|
by: Ludwig77 |
last post by:
I read that there are some tags that can be entered in a web page's
meta tags in order to prevent web bot searching and indexing of the
web page for search engines.
What is the tagging that I would need to use?
| | |
by: Thomas Christmann |
last post by:
Hi!
First let me apologize for asking this question when there are so many answers
to it on Google, but most of them are really contradicting, and making what I
want to do very performant is crucial to my project. So, here's what I have:
My C programm connects to a database and gets ca. 50-100K domain name/file path
pairs. Those pairs have to be cached by my application. Building the cache may
take a second or two, but retrieving from...
|
by: Walter Dnes (delete the 'z' to get my real address |
last post by:
I took a C course some time ago, but I'm only now beginning to use it,
for a personal pet project. My current stumbling-block is finding an
efficient way to find a match between the beginning of a "counted"
string and data in a binary file. Given...
#include <stdio.h>
int main(int argc, char *argv)
{
char bstring;
|
by: pbd22 |
last post by:
Hi.
I am somewhat new to this and would like some advice.
I want to search my xml file using "keyword" search and
return results based on "proximity matching" - in other words,
since the search string will often not produce a direct match,
the results will be based on proximity (50%, 20% 100%, etc).
are there any good examples out there on how to do keyword
searches on XML data? How should i set up my xml file so
|
by: daoxx |
last post by:
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
