F
FG
I have an Access table that contains just over 200 groups of data
identified by a unique # for each. Each group has monthly dates, and
twenty-five columns of data. Often the data in these columns on each
date matches the data for another group. I need to know the number of
overlaps between each group for each date as a total sum in order to
see the degree of correlation between each group. The result I'm
thinking of is a matrix that shows all groups along the x and y axis
and then the # of overlapping data points in each cell. Is there a
way in Access to accomplish this goal?
Any pointers or suggestions at all would be greatly appreciated.
identified by a unique # for each. Each group has monthly dates, and
twenty-five columns of data. Often the data in these columns on each
date matches the data for another group. I need to know the number of
overlaps between each group for each date as a total sum in order to
see the degree of correlation between each group. The result I'm
thinking of is a matrix that shows all groups along the x and y axis
and then the # of overlapping data points in each cell. Is there a
way in Access to accomplish this goal?
Any pointers or suggestions at all would be greatly appreciated.