Report format question (1 Viewer)

[arage]

Report format question
Each detail in my report has a cheque # column that shows either a cheque # or “Unpaid”
I put text in my footer that says ‘Your total of “Unpaid” cheques is’ and then there’s a text box. I put this code in my detail format event to get the value of total “Unpaid” cheques, but it keeps coming up blank, any help?

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

If Me.Cheque_ = "Unpaid" Then
Me.Text167 = Me.Text167 + Me.TotalPay
End If

End Sub

 

[llkhoutx]

you can't put the "total" in the footer, it has to be =sum([cheques amount]) where [cheques amount] is the field being displayed above the footer.