Operation =1
Option =0
Where ="(((ASSESSMT.ACCTNBR)=[ENTER ACCOUNT NUMBER]) 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].[a"
        "ssdshares]>0,[ASSESSMT].[assdshares]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\""
        "[YEAR]=\" & Year(Date())),0),0))-[amtpaid]+Nz(DLookUp(\"TotalCharge\",\"Billingr"
        "ecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Maintenance Fund"
        "'\"),Nz(DLookUp(\"OTHER\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNB"
        "R] & \" AND [Desc]='Annual Assessment'\"),Nz(DLookUp(\"OTHER\",\"ANNUALRT\",\"[Y"
        "EAR]=\" & Year(Date())),0)))"
    Alias ="YRASMT"
    Expression ="Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTN"
        "BR] & \" AND [Desc]='Annual Assessment'\"),IIf([ASSESSMT].[assdshares]>0,[ASSESS"
        "MT].[assdshares]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Dat"
        "e())),0),0))"
    Alias ="ratepershare"
    Expression ="Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)"
    Expression ="ASSESSMT.assdshares"
    Alias ="OTHERCHG"
    Expression ="Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTN"
        "BR] & \" AND [Desc]='Maintenance Fund'\"),Nz(DLookUp(\"OTHER\",\"Billingrecords\""
        ",\"[ACCTNBR]=\" & [ASSESSMT].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),Nz"
        "(DLookUp(\"OTHER\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)))"
    Expression ="Billingrecords.RATEPERshare"
    Alias ="coname"
    Expression ="\"Redlands Water & Power\""
End
Begin Joins
    LeftTable ="ASSESSMT"
    RightTable ="Billingrecords"
    Expression ="ASSESSMT.ACCTNBR = Billingrecords.ACCTNBR"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "PublishToWeb" ="1"
Begin
End
Begin
    State =2
    Left =-4
    Top =-23
    Right =800
    Bottom =485
    Left =-1
    Top =-1
    Right =797
    Bottom =180
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =7
        Right =168
        Bottom =129
        Top =11
        Name ="ASSESSMT"
        Name =""
    End
    Begin
        Left =206
        Top =6
        Right =302
        Bottom =113
        Top =2
        Name ="Billingrecords"
        Name =""
    End
End
