Another percentage question...

[Mobjack]

I have researched this through the forum and I could not find anyone with a similar situation.

I have a report that calculates the the totals of several fields and puts those numbers in a report. When you look at the report in design view, there is only one section in the details area, yet when you look at the report in print view there are up to 3 entries per section. I have check boxes used to calculate some of the label entries:

Option Compare Database

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If chkCheckedOut = "0" And chkCheckedIn = "0" Then
lblChecked.Caption = "Legacy Numbers On File"
ElseIf chkCheckedOut = "-1" And chkCheckedIn = "0" Then
lblChecked.Caption = "In Process"
Else: lblChecked.Caption = "Legacy with NPI"
End If

End Sub


Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)


If txtStatus = "1" Then
lblStatus.Caption = "Active"
Else
lblStatus.Caption = "Inactive"
End If

End Sub

My boss wants to get a percentage for each of these figures on the report now and I cannot for the life of me figure out how to go about doing this.

Can someone please help me out?

Thanks!