Solutions Database - Multiple-Column Report Question

[fredk]

I used the Multiple Column report sample in the developers database as a template (hopefully, someone is familiar with it)

I have a field called status and a field called result - There are three status/result combinations that have a status of "rel to mkt" I have added a status footer to this report and I want to total only the "rel to mkt" I used the following code which is mainly from the developers database and placed it in the status footer on print event procedure:

"For IntY = 3 To intColumnCount
If Me.stat1 = "Tot Rel To Mkt" Then
Me("stat" + Format(IntY)) = lngRgColumnTotal(IntY)
End If
Next IntY"

lngRgColumnTotal is declared in the General Declarations as such:

"Dim lngRgColumnTotal(1 To conTotalColumns) As Long"

From what I understand, this is an array -

The result I currently get is the entire total (of all status') I just want the total of each status group instead of all status'

I was able to do this on a regular report by using the if statement in the filed on the report. However, since this report determined the number of columns to use based on input, all fields are unbound and coding is required to achieve the result - thats where I need help!!!

I hope this makes sense - I appreciate any help, thanks!!

Fred