Operation =1
Option =0
Where ="(((User.ACCTNBR)=IIf(IsNull([Enter account number]),[user].[acctnbr],[Enter acco"
    "unt number])) AND ((User.shares)>0)) OR (((User.ACCTNBR)=IIf(IsNull([Enter accou"
    "nt number]),[user].[acctnbr],[Enter account number])) AND ((User.assdshares)>0))"
Begin InputTables
    Name ="User"
End
Begin OutputColumns
    Expression ="User.ACCTNBR"
    Expression ="User.FNAME"
    Expression ="User.LNAME"
    Expression ="User.Fname2"
    Expression ="User.LNAME2"
    Expression ="User.STREET1"
    Expression ="User.STREET2"
    Expression ="User.CITY"
    Expression ="User.STATE"
    Expression ="User.ZIP"
    Alias ="Year"
    Expression ="Year(Date())"
    Expression ="User.PREVSBAL"
    Expression ="User.AMTPAID"
    Expression ="User.FINCHG"
    Alias ="balance"
    Expression ="[finchg]+[prevsbal]+Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\""
        " & [User].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),IIf([User].[assdshare"
        "s]>0,[User].[assdshares]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & "
        "Year(Date())),0),0))-[amtpaid]+Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"["
        "ACCTNBR]=\" & [User].[ACCTNBR] & \" AND [Desc]='Maintenance Fund'\"),Nz(DLookUp("
        "\"OTHER\",\"Billingrecords\",\"[ACCTNBR]=\" & [User].[ACCTNBR] & \" AND [Desc]='"
        "Annual Assessment'\"),Nz(DLookUp(\"OTHER\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date("
        "))),0)))"
    Alias ="YRASMT"
    Expression ="Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [User].[ACCTNBR] "
        "& \" AND [Desc]='Annual Assessment'\"),IIf([User].[assdshares]>0,[User].[assdsha"
        "res]*Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0),0))"
    Alias ="ratepershare"
    Expression ="Nz(DLookUp(\"RATEPERshare\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)"
    Expression ="User.shares"
    Alias ="OTHERCHG"
    Expression ="Nz(DLookUp(\"TotalCharge\",\"Billingrecords\",\"[ACCTNBR]=\" & [User].[ACCTNBR] "
        "& \" AND [Desc]='Maintenance Fund'\"),Nz(DLookUp(\"OTHER\",\"Billingrecords\",\""
        "[ACCTNBR]=\" & [User].[ACCTNBR] & \" AND [Desc]='Annual Assessment'\"),Nz(DLookU"
        "p(\"OTHER\",\"ANNUALRT\",\"[YEAR]=\" & Year(Date())),0)))"
    Expression ="User.assdshares"
    Expression ="User.COMMENTS"
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBinary "GUID" = Begin
    0x3435691608c6274586f096935b8dad0d
End
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbBoolean "TotalsRow" ="0"
dbByte "PublishToWeb" ="1"
Begin
    Begin
        dbText "Name" ="User.COMMENTS"
        dbInteger "ColumnWidth" ="3705"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.LNAME"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.ACCTNBR"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="balance"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.FNAME"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.FINCHG"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.YRASMT"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.Fname2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.shares"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.LNAME2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.OTHERCHG"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.STREET1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.assdshares"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.STREET2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.AMTPAID"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.CITY"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.STATE"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.ZIP"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Year"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="User.PREVSBAL"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =88
    Top =146
    Right =1065
    Bottom =393
    Left =-1
    Top =-1
    Right =953
    Bottom =186
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =340
        Top =6
        Right =911
        Bottom =310
        Top =0
        Name ="User"
        Name =""
    End
End
