Group by and count if "Male"

[Bertrand82]

Hi,



I have a table with 2 columns:

Company and Gender

I would like to make a query which groups by Company and counts the values in column gender if gender value is "male"

br Bertrand

[redbull]

I am VERY BAD at queries... but I think it would look like this..

SELECT * FROM tablename
WHERE Gender is LIKE "MALE" or 'MALE'
GROUP BY Company

if the database does not have alot of sensitive stuff post it on here and I will mess around with it

[orange]

Try

SELECT Company
, COUNT(*) as "Number of Males" 
FROM YourTableNameHere 
WHERE 
gender = "male" 
GROUP BY 
Company;

[redbull]

Thank you orange, like I said I am very bad at queries... nice to know I was headed down the right road... sort of..

[orange]

There are excellent examples at http://www.techonthenet.com/sql/index.php

[Bertrand82]

Thank you, probloem solved with

There are excellent examples at http://www.techonthenet.com/sql/index.php

[orange]

Glad you got the problem solved.
Don't overlook Google and Youtube for solutions to Access, SQL and Database issues.