Select Query with multiple counts and multiple criteria

[becka11]

I have written a select query to give me the count of portfolio companies for a sector. However, I want to be able to return a count of portfolio companies by sector for multiple sectors. Here is my original query:



SELECT Count(GainEvent_bySector.PortfolioCoName) AS CountofGainEventCET
FROM GainEvent_bySector INNER JOIN PortfolioCompanies ON GainEvent_bySector.PortfolioCoName = PortfolioCompanies.PortfolioCoName
WHERE (((GainEvent_bySector.Sector)="Communications and Enabling Technologies"))

This gives me:
CountofGainLossCET (one sector)
21

I want:
CountofGainLossCET CountofGainLossCMA CountofGainLossDBA
21 25 42

Here is my structure:


Any assistance would be great!!!

[becka11]

The spacing didn't come out, but the CountofX, CountofY, countofZ are the columns and The 21,25,42 are the rows below the corresponding columns

[becka11]

Wow posting must have just given me good luck b/c I finally figured it out right after posting after spending a lot of time on it.

Here is the final SQL:
SELECT Count(GainEvent_bySector.PortfolioCoName) AS CountofGainEventSector, GainEvent_bySector.Sector
FROM GainEvent_bySector INNER JOIN PortfolioCompanies ON GainEvent_bySector.PortfolioCoName = PortfolioCompanies.PortfolioCoName
GROUP BY GainEvent_bySector.Sector;

happy!