Operation =1
Option =0
Begin InputTables
    Name ="qry_BonusVLtest"
    Name ="qry_BonusVLtest1"
    Name ="qry_BonusVLtest0_3"
End
Begin OutputColumns
    Expression ="qry_BonusVLtest.KW"
    Alias ="Netto Termin"
    Expression ="Sum(qry_BonusVLtest.[Netto Termin])"
    Alias ="Abschluss Kunden"
    Expression ="Sum(qry_BonusVLtest.Abschluss)"
    Alias ="Forecast Quote"
    Expression ="0.65"
    Alias ="Forecast"
    Expression ="Round([Netto Termin]*[Forecast Quote],0)"
    Expression ="qry_BonusVLtest1.[Anzahl Verträge]"
    Alias ="Netto Abschlussquote"
    Expression ="IIf([Abschluss Kunden]>0,[Abschluss Kunden]/[Netto Termin],0)"
    Alias ="Netto Vertrag Abschlussquote"
    Expression ="IIf([Anzahl Verträge]>0,[Anzahl Verträge]/[Netto Termin],0)"
    Alias ="Forecast prozentual erreicht"
    Expression ="Round([Anzahl Verträge]/[Forecast],2)"
    Expression ="qry_BonusVLtest0_3.[Anzahl AD]"
    Alias ="Bonus Stufe Netto Vertrag Abschlussquote"
    Expression ="IIf([Anzahl AD]>=19,IIf([Forecast prozentual erreicht] Between 1 And 1.09999,1,I"
        "If([Forecast prozentual erreicht] Between 1.1 And 1.199999,1.5,IIf([Forecast pro"
        "zentual erreicht]>=1.2,2.25,0))))"
    Alias ="Wochenbonus pro VL"
    Expression ="[Bonus Stufe Netto Vertrag Abschlussquote]*[Anzahl Verträge]"
    Alias ="Überweisungsbegtarg pro VL"
    Expression ="[Wochenbonus pro VL]*1.19"
    Alias ="Wochenbonus VL Summe"
    Expression ="[Wochenbonus pro VL]*2"
End
Begin Joins
    LeftTable ="qry_BonusVLtest"
    RightTable ="qry_BonusVLtest1"
    Expression ="qry_BonusVLtest.KW = qry_BonusVLtest1.KW"
    Flag =1
    LeftTable ="qry_BonusVLtest1"
    RightTable ="qry_BonusVLtest0_3"
    Expression ="qry_BonusVLtest1.KW = qry_BonusVLtest0_3.KW"
    Flag =1
End
Begin Groups
    Expression ="qry_BonusVLtest.KW"
    GroupLevel =0
    Expression ="qry_BonusVLtest1.[Anzahl Verträge]"
    GroupLevel =0
    Expression ="qry_BonusVLtest0_3.[Anzahl AD]"
    GroupLevel =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="Netto Abschlussquote"
        dbText "Format" ="Percent"
        dbInteger "ColumnWidth" ="2100"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Netto Vertrag Abschlussquote"
        dbText "Format" ="Percent"
        dbInteger "ColumnWidth" ="2790"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Wochenbonus pro VL"
        dbText "Format" ="#,##0.00 €;-#,##0.00 €"
        dbInteger "ColumnWidth" ="2055"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Bonus Stufe Netto Vertrag Abschlussquote"
        dbText "Format" ="#,##0.00 €;-#,##0.00 €"
        dbInteger "ColumnWidth" ="3915"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Wochenbonus VL Summe"
        dbText "Format" ="#,##0.00 €;-#,##0.00 €"
        dbInteger "ColumnWidth" ="2460"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Abschluss Kunden"
        dbInteger "ColumnWidth" ="1815"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Forecast prozentual erreicht"
        dbInteger "ColumnWidth" ="2610"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
    End
    Begin
        dbText "Name" ="Überweisungsbegtarg pro VL"
        dbInteger "ColumnWidth" ="2670"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-25
    Right =3440
    Bottom =1246
    Left =-1
    Top =-1
    Right =3433
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =543
    Begin
        Left =43
        Top =14
        Right =139
        Bottom =123
        Top =4
        Name ="qry_BonusVLtest"
        Name =""
    End
    Begin
        Left =394
        Top =13
        Right =490
        Bottom =92
        Top =0
        Name ="qry_BonusVLtest1"
        Name =""
    End
    Begin
        Left =878
        Top =4
        Right =974
        Bottom =83
        Top =0
        Name ="qry_BonusVLtest0_3"
        Name =""
    End
End
