Simple query

[morlan]

Hello people, what a pleasent day it is.
I was wondering if you could help me with this simple query.


Here's my table:

tblMain

ID-----SalesExec----PPP

001---John-----------0
002---John-----------1
003---John-----------1
004---John-----------1
005---Fred-----------0
006---Fred-----------0
007---Fred-----------1
008---Pat------------1
009---Pat------------0
010---Pat------------0


Simple query:

Count '1' in PPP column = PPP_TakeUp
Count ID to get total records = Total


Query result:

qryPPP_TakeUp

SalesExec ----PPP_TakeUp--------Total

John-----------3----------------------4
Fred-----------1----------------------3
Pat-------------1---------------------3


Any help appreciated!

 

[Mile-O]

Is there a question to accompany that or were just wanting to show us all your query?

 

[morlan]

Is there a question to accompany that or were just wanting to show us all your query?

Of course, read again

 

[Mile-O]

Still don't see a question but I'm guessing that the bit at the bottom is your desired result. Questions are typically concluded with a ?

Still, since I'm guessing you are looking for the result at the bottom, here's the SQL

SELECT tblMain.SalesExec, Sum(tblMain.PPP) AS PPP_TakeUp, Count(tblMain.PPP) AS Total
FROM tblMain
GROUP BY tblMain.SalesExec;

 

[morlan]

Thanks m8.

Heres a question:

What and where is the world's largest sculpture?

 

[Mile-O]

What and where is the world's largest sculpture?

Now, do you mean the largest man-made sculpture in the world, or the world's largest sculpture (i.e. scultped by nature) ?

 

[morlan]

Now, do you mean the largest man-made sculpture in the world, or the world's largest sculpture (i.e. scultped by nature) ?

Manmade... tip: it was only erected in the past year and resides in Europe...

 

[Mile-O]

Tate Modern

 

[Brianwarnock]

I appreciate that Crazy Horse is not completed yet , but why is Mount Rushmore discounted from the answer? Surely its bigger than any indoor sculpture or did I miss something?

Brian

 

[Mile-O]

Manmade

Not menmade. Rushmore, itself, was never completed either - I think it has been since.

 

[Brianwarnock]

Wow talk about splitting hairs! Yep as far as I know Mt Rushmore is now complete

Brian