Crosstab

N

nir020

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
 
J

Jerry Whittle

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.
 
K

KARL DEWEY

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