ehrlich
10-28-2003, 05:48 AM
I have a table with 40 columns which I call data points.
Each record has a date. Each data point is either a numeric
score or a yes/no. I want a report with the headings across the top being the last six months; the headings down the side being the 40 data points; the cells should be an average, if the data point is a number, or a count if the data point is a yes-no. Cross tab query is not the answer because it will only allow 3 fields down the side. Please help. Thanks, Ron E.
Each record has a date. Each data point is either a numeric
score or a yes/no. I want a report with the headings across the top being the last six months; the headings down the side being the 40 data points; the cells should be an average, if the data point is a number, or a count if the data point is a yes-no. Cross tab query is not the answer because it will only allow 3 fields down the side. Please help. Thanks, Ron E.