Count number of Occurences in columns

[Vexorg]

Hello,

I cant seem to figure this out below is my table:

<TABLE cellSpacing=0 bgColor=#ffffff border=1><CAPTION>Sheet2</CAPTION><THEAD><TR><TH borderColor=#000000 bgColor=#c0c0c0>Timeliness</TH><TH borderColor=#000000 bgColor=#c0c0c0>Accuracy</TH><TH borderColor=#000000 bgColor=#c0c0c0>Issue Resolution</TH><TH borderColor=#000000 bgColor=#c0c0c0>Fail Resolution and Reporting</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>2</TD><TD borderColor=#d0d7e5>4</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5>4</TD><TD borderColor=#d0d7e5>-</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5>3</TD><TD borderColor=#d0d7e5>4</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5>3</TD><TD borderColor=#d0d7e5>3</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5>3</TD><TD borderColor=#d0d7e5>3</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5>3</TD><TD borderColor=#d0d7e5>3</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5>3</TD><TD borderColor=#d0d7e5>3</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5>-</TD><TD borderColor=#d0d7e5>3</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5>3</TD><TD borderColor=#d0d7e5>3</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>5</TD><TD borderColor=#d0d7e5>5</TD><TD borderColor=#d0d7e5>4</TD></TR></TBODY><TFOOT></TFOOT></TABLE>

I want to count the number of times a 1,2, or 3 occurs in each column.. is there a simple way to do this?

 

[boblarson]

In your query you can use these to make columns which count

CountOfTimeliness_1s: Sum(IIf([Timeliness] = 1, 1, 0))

CountOfTimeliness_2s:Sum(IIf([Timeliness] = 2, 1, 0))

CountOfTimeliness_3s:Sum(IIf([Timeliness] = 3, 1, 0))

CountOfAccuracy_1s:Sum(IIf([Accuracy] = 1, 1, 0))

CountOfAccuracy_2s:Sum(IIf([Accuracy] = 2, 1, 0))

CountOfAccuracy_3s:Sum(IIf([Accuracy] = 3, 1, 0))


and you can do it just like that for each of the columns.