Single Invoices - HELP

[smeagain]

HI, I am using the Time & Billing template supplied by Microsoft for my Database. The template has a pre designed report which creates an Invoice. The problem with this report is that it shows running totals rather than a sngle invoice as I reuire. ANY IDEAS ????
If you want an example please let me know

 

[Simon_MT]

When you open the report A command Button with a script filters the report.

Function ClientsSales_Print()
    With CodeContextObject
        DoCmd.GoToControl "Client Sale Date"
        Call IsDirty
            If .[Client Sale Inv Status] = "P" Then
                DoCmd.OpenReport "Originals Sales Invoice Proforma", acViewReport, "", "[Client Sale Exist Inv No]= " & .[Client Sale Exist Inv No], acWindowNormal
            Else
                DoCmd.OpenReport "Originals Sales Invoice", acViewReport, "", "[Client Sale Exist Inv No]= " & .[Client Sale Exist Inv No], acWindowNormal
            End If
    End With
End Function

Simon