Access database. What is the best method to count a field that has the
numbers 1 - 93 in it, over 1008000 rows long. Trying to obtain how many
times 1, 2, 3 etc show up in this field.
Jeff
"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:uc*************@TK2MSFTNGP11.phx.gbl...
Access database. What is the best method to count a field that has the numbers 1 - 93 in it, over 1008000 rows long. Trying to obtain how many times 1, 2, 3 etc show up in this field.
Just in case:
You decided to use a grouping query with the Count(*) aggregate function,
right? You didn't bring all the records to the client and loop through them,
did you ...?
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Just my two cents, but it sounds like a candidate for a database upgrade.
"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:uc*************@TK2MSFTNGP11.phx.gbl...
Access database. What is the best method to count a field that has the numbers 1 - 93 in it, over 1008000 rows long. Trying to obtain how many times 1, 2, 3 etc show up in this field.
Yes, its going to MS-SQL. Did it by doing:
SELECT [Locality_Code], Count(*) AS Total
FROM Voters
GROUP BY [Locality_Code];
Thanks
Jeff
"Tom B" <sh*****@NOSPAMhotmail.com> wrote in message
news:uo**************@TK2MSFTNGP11.phx.gbl...
Just my two cents, but it sounds like a candidate for a database upgrade.
"Jeff Uchtman" <uc*****@megavision.com> wrote in message news:uc*************@TK2MSFTNGP11.phx.gbl...
Access database. What is the best method to count a field that has the numbers 1 - 93 in it, over 1008000 rows long. Trying to obtain how many times 1, 2, 3 etc show up in this field.
Hello Experts!
I reading a book called programming with design pattern revealed
by Tomasz Muldner and here I read something that I don't understand
completely.
It says
"A garbarage...
Hello Experts!
I reading a book called programming with design pattern revealed
by Tomasz Muldner and here I read something that I don't understand
completely.
It says
"A garbarage...
I appreciate the help on this group. I know I've posted a lot here the last
couple of weeks, but I was thrown into a database project at my work with
very little Access experience. No other...
Hi,
I've been trying to do line/character counts on documents that are
being uploaded. As well as the "counting" I also have to remove
certain sections from the file.
So, firstly I was working...
We have a 10-question quiz for kids, each question being a yes or no
answer using radio selections. I'd like to keep a current total of
yes's and no's at the bottom of the quiz (if the user selects...
Hi,
Please consider the following class (it's not really my class, but it's
a good example for my question):
class Vector {
int myN;
double *myX;
Vector(int n) : myN(n), myX(new double) { }...
I'm writing a TCP/IP server app that will have many simultaneous
connections. The main thread listens for new connections and starts a
thread to handle each requested connection. These are short...
I have a next situation with the textbox field:
A - B = C
1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every...
I have a question which involves reading from cin and counting the number of words read until the end of file(eof).
The question is as follows:
Words are delimited by white spaces (blanks,...
Hello,
I have a question refering python's reference counting/garbage
collection in combination with thrown exceptions.
I'm very new to this mailinglist, so I hope, that this question has not...
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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,...
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...