Crosstab

[Guest]

I have the following table in my database:-

ID|Age|Gender|Ethnicity
1 12 Male W1
2 13 Female B1

From which I created the following crosstab:-

Male | Female

12 1 0
13 0 1

It is possible to add an additonal filter to this crosstab so the user can
query for spefic ethnic groups

 

[Guest]

First create a query on the table that has a parameter for Ethnicity or some
other way define the Ethnicity.

Next create the crosstab query on the first query instead of the table.

 

[Guest]

Open the query in design view and add a column designated as a row named
Ethnicity.