H
Hennie
Good day,
I need to run a number of crosstab queries where the column headings is
based on race. The row data will be either male or female, while the row
heading could be Faculty, department, ect. At the end of the day the male
and female data need to be combined into one report so that you would have
the number of males and females for each of the four races. In the second
last query I join the result of the crosstab with the race table to create a
field incase there is no data for one or two races as the report requires
all four races.
If there is no data for a race it creates a field <>.
How could I check if there is a field for say, Race2, if there is use the
data for Race2, if not create the heading or field for Race2.
Im using Access 2002.
Thank you for your time.
Hennie
I need to run a number of crosstab queries where the column headings is
based on race. The row data will be either male or female, while the row
heading could be Faculty, department, ect. At the end of the day the male
and female data need to be combined into one report so that you would have
the number of males and females for each of the four races. In the second
last query I join the result of the crosstab with the race table to create a
field incase there is no data for one or two races as the report requires
all four races.
If there is no data for a race it creates a field <>.
How could I check if there is a field for say, Race2, if there is use the
data for Race2, if not create the heading or field for Race2.
Im using Access 2002.
Thank you for your time.
Hennie