SQL in Frontpage/Access

J

Jim

I have a database with a table called "listing" The fields I'm trying to
work with are 'Year', and 'Description'

The result I am looking for is a 3 column table showing the Year, the count
of records for that year, and the count of records matching a specific
description for each year:

I.E.
Year Total Matches
1960 10 2
1961 20 0
1962 6 5

I have been able to get the first two columns with the query below, but
cannot figure how to get the third column which would show how many of the
years total match the description I want. For example how many records of
the total for a year have the description "Completed"

SELECT DISTINCTROW Listing.Year, Count(*) AS [Count Of Listing]
FROM Listing
GROUP BY Listing.Year;

Any help would be appreciated.

Jim Clavin
 
V

Vadim Rapp

Hello Jim,
You wrote in conference microsoft.public.access.adp.sqlserver on Tue, 2 Aug
2005 20:35:13 -0400:

J> I have a database with a table called "listing" The fields I'm trying to
J> work with are 'Year', and 'Description'

J> The result I am looking for is a 3 column table showing the Year, the
J> count of records for that year, and the count of records matching a
J> specific description for each year:

J> I.E.
J> Year Total Matches
J> 1960 10 2
J> 1961 20 0
J> 1962 6 5

J> I have been able to get the first two columns with the query below, but
J> cannot figure how to get the third column which would show how many of
J> the years total match the description I want. For example how many
J> records of the total for a year have the description "Completed"

In a query, you can group by only one dimension. In this case, you need to
use nested queries, along these lines:

select year,
(select count(*) from mytable t where t.year=mytable.year and
criteria1=true),
(select count(*) from mytable t where t.year=mytable.year and
criteria2=true),
....
from mytable
 
G

Gerardo Ugarte

Hi, how are you? .

The reason for which I'm writing you is quite simple... I just want you to
take part in a big movement that is happening on Internet, and maybe you
still don´t know about that... Well, this is about...



THE EASIEST TECHNIQUE TO EARN MONEY!!!



Believe me when I say it's real and not just another trick

You can earn U$S 15.000 in one month.... (if you don´t believe, at least
take yourself a moment to read what's this about)

The only way to know this is not a trick is just using logic and
intelligence and so you'll realize that money multiplies. I ask you to think
and analyze what is described in next lines... I swear it's true



EARN MANY U$S FROM HOME!!

I'm sure your time has got a worth, but I assure you that if you read this
letter, the time you invert on it will be more than well rewarded.



Before anything, it's important you know that in the world there's a lot of
money, but it's distributed in a wrong way; well, this is the solution of
the problem. The matter is not that little give much, the matter is that
much give little.





Some days ago, I read a similar article that said it's possible to earn
thousands of dollars with just a SIX DOLLARS INVERSION (U$S 6).



Inmediately I thought "Oh, no! ¿Another trick?" But, as many of us, my
curiosity was stronger and I went on reading. It said: if you send one
dollar to the six names and addresses mentioned in this article, and write
your name, address and zip code at the end of the list replacing number 6,
and send this article at least to 200 newsgroups (there are thousands of
these in the web) you'll receive, from all the world up to U$S 15.000 or
even more!!

In other words, the only thing you might lose is six seals and six dollars.



Let me explain to you how this works and the most important: WHY THIS WORKS.
Be sure to print a copy of this article NOW, to have all the information
when you need it. The process is very simple and has three easy steps:




STEP nº 1



Get 6 paper sheets and write on all of them "PLEASE, INCLUDE ME IN YOUR
CORRESPONDENCE LIST", with your name, address and e-mail. Now, get 6 ONE
DOLLAR bills and introduce each dollar with the sheet, trying to cover the
bill (try to use a dark peace of paper to avoid robberies in the
correspondence). Now, you must have six sealed letters with the paper sheet
with the phrase mentioned, your name, your address and one dollar bill. What
you are doing is creating a service, making this completley LEGAL!!!


As a nice detail, write also the position of every name when you sent the
dollar (For example: "you were in slot 3") to make it more complete!! This
is the matter, to make money and and have fun at the same time.

Send the six letters to the next addresses:


1. Marco Arosemena M.
Apartado 87-2843, Zona 7
Panamá, REP. DE PANAMÁ

2. Daniel N. Mesta
405 North 14th Street
Phoenix, Arizona, USA 85006

3. Jesus Treviño Hernandez
C/ Juan Suarez de Peralta #2741
Col. Jardinez de la Paz
Tlaquepaque. Jalisco
MEXICO

4. Victor A. Lencina
De la Peña 1525 ( Wilde )
C.P: 1875 Buenos Aires
ARGENTINA

5. Leopoldo C. Chew
Topiltzin # 312 Col. Rodriguez
CP. 89170
Tampico, Tamaulipas

MEXICO



6. Gerardo Ugarte Valencia

Calle Hermanos Andrade #180 Urb. El Bosque
CP Lima 25

Rímac, Lima

PERU




STEP nº 2
Now delete the first name in the list and move the other names one number up
(nº 6 becomes 5, nº 5 becomes 4, etc), and INCLUDE YOUR DATA IN NUMBER 6 OF
THE LIST



STEP nº 3
Change what you consider necessary of this article, and post it on at least
200 newsgroups (there are more than 24 000 groups) and send it directly to
200 e-mails (there are millions). You just need 200, but if you send more,
you'll get more money.



If you know BBS, much better... when you publish this article, try to write
an interesting tittle... like for example.. "DO YOU NEED FAST MONEY? READ
THIS ARTICLE". "DO YOU NEED TO PAY YOUR DEBTS?", ETC.


LET'S COMPROMISE TO BE HONEST, GIVING A HUNDRED TWENTY PERCENT OF US TO MAKE
THIS WORKS. The system will work only if we do what is correct to make money
move. That's the idea!! You`ll get surprised with the results, believe me!!!



Now, WHY IS THIS TRUE??


From 200 sents (among newsgroups and e-mails), let's say we just get 5
answers (very low example). So I would make five dollars with my name in
position number 6 of that letter. Now, each one fo the five persons that
sent me U$S 1 send also a minimum of 200 newsgroups and e-mails, each one
with my name in number 5, and they get just five answers... that makes me
receive another 25 dollars... Now, these 25 persons send a minimun of 200
newsgroups and e-mails with my name in number 4, and they also get just 5
answers... I would be making another 125 dollars. AND NOW, these 125 people
send their 200 newsgroups and e-mails with my name in number 3 and the get 5
answers.. I'd make 625 more dollars!!!



Ok. Now comes the funniest way... each one fo these 625 persons will send
the article to another 200 newsgroups and e-mails with my name in number 2
and each one of them gets only 5 answers... So now I would be making U$S 3
125!!!. These persons repeat the process with my name in number 1 and I
would get U$S 15 625!!.



FROM AN INVERSION OF JUST SIX DOLLARS!!!!



GREAT!! And as I said befote, five answers is a very low example. So imagine
all the money you can get in a easy, funny and fast way!!!!!



HOW TO MANGE THE NEWSGROUPS



Nº.1> You don't need to redact the whole letter to make yours. Just copy it
and save it in you PC as a text file.




Nº.2> Now, you may change all the things you consider necessary.



IF YOU USE NETSCAPE


Nº.3> Inside Netscape program, go to "COMMUNICATOR" and select "GROUPSNEWS"
Now, click on any of the newsgroups that will appear... Inside this
newsgroup, click on "TO NEWS". Now you'll be in the messages box.



Nº.4> Fill that space. That will be the tittle everybody that goes through
that group will see.



Nº.5> Paste your letter inside the program... Then press "SEND"
AND YOU JUST FINISHED WITH YOUR GIRST GROUP. CONGRATULATIONS!!!


IF YOU USE INTERNET EXPLORER


Nº. 3: Go to Newsgroups and select to post an article. Or to post an
announcement, etc.


Nº. 4: Paste the article the same way used in NETSCAPE.. and THAT'S ALL


You just have to enter in different newsgroups and paste them, and when you
get practice, every new newsgroup will take you just 30 seconds!!!

MAKE SURE ALL THE ADDRESSES ARE WRITTEN CORRECTLY

When time goes by and your name doesn't appear in the list, take the last
announcement of the newsgroup and send 6 dollars to the names in that list,
putting down your name in number 6, repeating the whole proccess.



What you have to keep always in mind is that THOUSANDS of people, all over
the world, connect to Internet everyday and they'll read these articles
everyday, just like YOU AND ME DO NOW!!!!



This way, I think nobody will have troubles to invert 6 dollars and see if
this really works. Some people could say... "And... if nobody decides to
answer me??



What? What's the possibility of this when there are thousands of thousands
of people (like us) that are looking for a way to get financial independence
and pay their debts?? And they're disposed to try... It's estimated that
there are 50 000 to 70 000 new users of Internet EVERY SINGLE DAY!!!



Let's review the reasons for doing this:

The only costs are 6 seals, 6 envelopes and six dollars (One dollar bill for
each one in the list), then publish again the article INCLUDING YOUR NAME in
all the newsgroups or BBS that you want (this is free), send as many e-mails
as you want (remember, more e-mails mean more money) and then JUST WAIT for
the letters. We all have six dollars for a simple inversion that doesn't
mean any kind of effort.



Remember to be honest and this system will work successfully. Be sure to
print the article now, try to keep the list of all the people that send you
money, and see in the newsgroups if everybody is taking place fairly.
Remember, HONESTY IS THE BEST WAY



THAT'S ALL!! All you have to do is go in different newsgroups and post the
articles there, and when you get practice, every new newsgroup will take you
just 30 seconds!!



REMEMBER, THE MORE NEWSGROUPS YOU GET ADN THE MORE E-MAILS YOU SEND, THE
MORE MONEY YOU'LL GET

BUT YOU HAVE TO GO IN AT LEAST 200 NEWSGROUPS

ANOTHER EXCELLENT WAY IS GETTING E-MAILS, AT LEAST 200 ADRESSES (THE BIGGER
NUMBER, THE MORE MONEY) THIS RESULTS FROM 5% TO 15%



AND IT'S DONE!!... you'll be receiving money from all over the world, from
place you don't even know, and in a short time!! If you prefer, use
nicknames, as long as the postman deliver the mail in the right place


JUST SIT AND ENJOY; 'CAUSE MONEY IS ON THE WAY!!! Expect for a little amount
of money during the second week, but since the third one.. A THUNDER OF
LETTERS in your inbox!!!



All you have to do is receive it, and try not to scream so loud when you
realize that this time you got it!!!



It's time to pay your debts and buy something special for you or for that
special person in your life, a gift you'll never forget. ENJOY LIFE!!!


And when you need money again, just reactivate this file and resend i ton
the same places you're gonna do now, and another new places you'l know in
the future. Always keep by your hand this article, and reactivate it every
time you need money



IT'S AN INCREDIBLE TOOL... YOU ALWAYS MAY USE AGAIN WHEN YOU NEED MONEY IN A
FAST WAY


HONESTY

IS WHAT MAKES THIS PROGRAM SUCCESSFUL. DON'T FORGET IT
GOOD LUCK!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top