Showing SQL Result [solved]

[bell]

Hello
I have an Access database where I have a field named "parSex" where it is holding participants gender (sex) as M or F

Now I want to run an sql statement in Access to count the number of Males and females and show the result as

M F
xx yy

When I use

SELECT TRG_PARTICIPANTS.parSex, Count(TRG_PARTICIPANTS.parSex) AS CountOfparSex
FROM TRG_SESSION INNER JOIN TRG_PARTICIPANTS ON TRG_SESSION.sessionId = TRG_PARTICIPANTS.sessionId
GROUP BY TRG_PARTICIPANTS.parSex;

I get this

ParSex Count
M xx
F yy

Thanks in advance

[anhn]

SELECT -SUM(TRG_PARTICIPANTS.parSex="M") AS Males, 
-SUM(TRG_PARTICIPANTS.parSex="F") AS Females
FROM TRG_SESSION INNER JOIN TRG_PARTICIPANTS 
ON TRG_SESSION.sessionId = TRG_PARTICIPANTS.sessionId;

[bell]

Thanks it worked