var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Crosstab Query Problem
I am trying to produce a Cross Tab query in Access and wondered if what i was trying to do is possible and if it is if somebody could point me in the right direction.
My Data is:
ApplicationID Successful Date Group
1 YES 01/02/04 Group1
2 NO 01/02/04 Group1
3 NO 01/03/04 Group2
The Query i'm trying to produce trying to get the number of applicants who have been successful each month and break that down by Group, for example:
Group1 33% 0%
Group2 0% 0%
I'm struggling to get my head around this on. Any help would be appreciated!!