I have a table with several checkboxes, to denote tests passed. A checked box denotes a passed test, an unchecked box denotes a failed test.
For example:
[ ] part1
[ ] part2
[ ] part3
[ ] part4
[ ] part5
Another table lists the participant's characteristics, such as Date of Birth, Gender, etc.
A simple query (qryTestResults) combines both tables, which are related by an ID number.
I wish to develop a report that shows the total number of each passed test, separated by Gender and age above & below 25 yrs.
I would like the results to look something like this (note that I'm using periods only to set the row heading spacing in this message)
.........................Part1....Part2....Part3....Part....Part5
Male <25
Male >= 25
Female <25
Female >= 25
I'm having two problems.
1. What expression do I use to count the total number of checked checkboxes in each category/column (part1, part2, etc)?
2. Can I do this in a single crosstab query, or should I use 2 (or more) crosstab queries, one for Gender=Male and one for Gender=Female?
I'm assuming that whatever query(s) I use, should be based on the simple query (qryTestResults), but I may be wrong, and perhaps should take the data directly from the 2 tables.
I somehow need to get the data into a single crosstab query so that I can create a chart of the results.
All suggestions are appreciated.
Thanks,
Shin
For example:
[ ] part1
[ ] part2
[ ] part3
[ ] part4
[ ] part5
Another table lists the participant's characteristics, such as Date of Birth, Gender, etc.
A simple query (qryTestResults) combines both tables, which are related by an ID number.
I wish to develop a report that shows the total number of each passed test, separated by Gender and age above & below 25 yrs.
I would like the results to look something like this (note that I'm using periods only to set the row heading spacing in this message)
.........................Part1....Part2....Part3....Part....Part5
Male <25
Male >= 25
Female <25
Female >= 25
I'm having two problems.
1. What expression do I use to count the total number of checked checkboxes in each category/column (part1, part2, etc)?
2. Can I do this in a single crosstab query, or should I use 2 (or more) crosstab queries, one for Gender=Male and one for Gender=Female?
I'm assuming that whatever query(s) I use, should be based on the simple query (qryTestResults), but I may be wrong, and perhaps should take the data directly from the 2 tables.
I somehow need to get the data into a single crosstab query so that I can create a chart of the results.
All suggestions are appreciated.
Thanks,
Shin