Access 2007
I need help with creating a query to show the number of visitors by countries, further breaking it down to gender distribution (i.e. by number of male and number of female visitors for a particular country).
An example showing sample data:
---------------------------------------
Country | Number of Visitors | F | M |
---------------------------------------
XXXX | XXX | X | X |
I searched around the web for help and couldnt find one after two days.
I figured out how to do that Country and Number of Visitors.
For example
Singapore | 7 |
But how do i break it up to Female and Male so it will show like
Singapore | 7 | 5 | 2
I need help with creating a query to show the number of visitors by countries, further breaking it down to gender distribution (i.e. by number of male and number of female visitors for a particular country).
An example showing sample data:
---------------------------------------
Country | Number of Visitors | F | M |
---------------------------------------
XXXX | XXX | X | X |
I searched around the web for help and couldnt find one after two days.
I figured out how to do that Country and Number of Visitors.
For example
Singapore | 7 |
But how do i break it up to Female and Male so it will show like
Singapore | 7 | 5 | 2
Last edited: