Operation =1
Option =0
Where ="(((ASSESSMT.ACCTNBR)=IIf(IsNull([Enter account number or press <Enter>]),[assess"
    "mt].[acctnbr],[Enter account number or press <Enter>])) AND (([finchg]+[prevsbal"
    "]+[yrasmt]+[otherchg]-[amtpaid])>[Enter the minimum balance for past due stateme"
    "nts]) AND ((ASSESSMT.assdshares)>0))"
Begin InputTables
    Name ="ASSESSMT"
    Name ="Billingrecords"
End
Begin OutputColumns
    Expression ="ASSESSMT.ACCTNBR"
    Expression ="ASSESSMT.FNAME"
    Expression ="ASSESSMT.LNAME"
    Expression ="ASSESSMT.Fname2"
    Expression ="ASSESSMT.LNAME2"
    Expression ="ASSESSMT.STREET1"
    Expression ="ASSESSMT.STREET2"
    Expression ="ASSESSMT.CITY"
    Expression ="ASSESSMT.STATE"
    Expression ="ASSESSMT.ZIP"
    Alias ="Year"
    Expression ="Year(Date())"
    Expression ="ASSESSMT.PREVSBAL"
    Expression ="ASSESSMT.AMTPAID"
    Expression ="ASSESSMT.FINCHG"
    Alias ="balance"
    Expression ="[finchg]+[prevsbal]+Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),IIf([ASSESSMT].[assdshares]>0,[ASSESSMT].[assdshares]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0),0))-[amtpaid]+Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Maintenance Fund'\"),Nz(DLookUp(\"OTHER\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),Nz(DLookUp(\"OTHER\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)))"
    Alias ="YRASMT"
    Expression ="Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),IIf([ASSESSMT].[assdshares]>0,[ASSESSMT].[assdshares]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0),0))"
    Alias ="ratepershare"
    Expression ="Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)"
    Expression ="ASSESSMT.assdshares"
    Expression ="Billingrecords.Ratepershare"
    Alias ="amtdue"
    Expression ="[prevsbal]+Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),IIf([ASSESSMT].[assdshares]>0,[ASSESSMT].[assdshares]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0),0))+Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Maintenance Fund'\"),Nz(DLookUp(\"OTHER\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),Nz(DLookUp(\"OTHER\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)))-[amtpaid]"
    Alias ="CONAME"
    Expression ="\"Redlands Water & Power Company\""
    Expression ="ASSESSMT.Interestpaid"
End
Begin Parameters
    Name ="Enter the minimum balance for past due statements"
    Flag =5
End
Begin Joins
    LeftTable ="ASSESSMT"
    RightTable ="Billingrecords"
    Expression ="ASSESSMT.ACCTNBR = Billingrecords.ACCTNBR"
    Flag =2
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="-1"
Begin
    Begin
        dbText "Name" ="balance"
        dbText "Format" ="$#,##0.00;($#,##0.00)"
    End
    Begin
        dbText "Name" ="amtdue"
        dbText "Format" ="$#,##0.00;($#,##0.00)"
    End
    Begin
        dbText "Name" ="ASSESSMT.FINCHG"
        dbText "Format" ="$#,##0.00;($#,##0.00)"
        dbByte "DecimalPlaces" ="2"
    End
    Begin
        dbText "Name" ="CONAME"
        dbInteger "ColumnWidth" ="3195"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-23
    Right =800
    Bottom =483
    Left =-1
    Top =-1
    Right =797
    Bottom =180
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =7
        Right =168
        Bottom =129
        Top =17
        Name ="ASSESSMT"
        Name =""
    End
    Begin
        Left =206
        Top =6
        Right =302
        Bottom =113
        Top =3
        Name ="Billingrecords"
        Name =""
    End
End
