Re: Group by and Sum in same query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"TKM" <TKM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:908137EA-F91D-4206-8C50-7E78324B77D0@xxxxxxxxxxxxxxxx
Chris,

Thanks for your reply. Your helped me along until I got it but one
thing as
I thought would happen. Because I need a total count for each plan
it would
only work in a report. When you have multiple of anything you will
get that
in your results as you already know. Anyway here is what I came up
with that
works almost what I needed but still not exactly..


TKM,

SELECT CMPSOWNER_FUNDDESC.FD_DESC_CD
,Count(CMPSOWNER_UNITS_BUY_SELL.BUY_SELL_UNIT_CT) AS [TOTAL
FUNDS]
FROM CMPSOWNER_FUNDDESC
INNER JOIN
CMPSOWNER_UNITS_BUY_SELL
ON CMPSOWNER_FUNDDESC.FD_DESC_CD =
CMPSOWNER_UNITS_BUY_SELL.FD_DESC_CD
GROUP BY CMPSOWNER_FUNDDESC.FD_DESC_CD;

Ok, I now have your current SQL attempt (as discussed in the post I
made a few minutes ago on another branch of this thread).

I still don't know what is supposed to generate (with certainty),
and what it is generating right now that does not match (and
therefore cannot offer a diagnosis that is anything other than
another "shot in the dark").

A few simple charts of actual data (source, desired results, and
current incorrect results) are worth a thousand words.


Sincerely,

Chris O.


.

Relevant Pages

  • Re: Rickys 85 false simple mechanisms
    ... Try including the room's rigid escape and Chris will obtain you! ... struggled, you recommended, yet Abdul never automatically remained ... worth the reservation. ...
    (sci.crypt)
  • Re: Staying together for the sake of the Kids?
    ... worth a shot don't you think everyone??? ... You may want to consider counseling so you both can learn how to deal with mental health and your marriage problem. ... In regards of making decisions I learned in therapy to make a list. ... Good luck, Chris. ...
    (alt.support.stop-smoking)
  • Re: AN OPEN LETTER TO THE OWNER OF GEN-MEDIEVAL, ET AL...
    ... guise of genealogy and who has had his material repeatedly ... and it is well worth the $94 it ... It is indeed touching, chris, to see the selfless loyalty with which ... david hughes, as he signs his name in Usenet messages). ...
    (soc.genealogy.medieval)
  • Re: Address Book
    ... I think Michael Santovec 6/29 post may be worth looking into. ... Check file association for .WAB, it most likely is incorrect. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Jeppesen Garmin Nav Updates
    ... For me I felt that it was worth it only because it was part of flying and the associated costs. ... I used to use Jepp paper charts, but they were expensive and covered TX and the surrounding states. ... I ordered though Sportys (always hoping that all my purchases would win one of their airplane give aways). ...
    (rec.aviation.ifr)