Grand total of current stock report

Mick Kobayashi 0 Reputation points

User's image

I want to get grand total of current stock in the blank square at the bottom, but cannot figure out how.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
830 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ken Sheridan 2,671 Reputation points

    Normally this would simply require the repetition of the expression used to return the Current Stock values in the group footer, either in the Report Footer, or in a higher level group footer.

    Note that values cannot be aggregated directly in a Page Footer. To return page totals use an unbound control in the Page Footer, and initialise and increment the values per page in the report's module, as in the example below:

    Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer)
        'reinitialise page total control to zero
        Me.txtPageTotal = 0
    End Sub
    Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
        If PrintCount = 1 Then
            Me.txtPageTotal = Me.txtPageTotal + Me.PaymentAmount
        End If
    End Sub
    0 comments No comments