Operation =1
Option =0
Begin InputTables
    Name ="qry_TL_Energie_Termine2_SummeNachTeam"
    Name ="qry_TL_Energie_Vertrag2_SummeNachTeam"
    Name ="qry_TL_Energie_KundeStorno2_SummeNachTeam"
End
Begin OutputColumns
    Expression ="qry_TL_Energie_Termine2_SummeNachTeam.id_verkaufteam"
    Expression ="qry_TL_Energie_Termine2_SummeNachTeam.name_vet"
    Expression ="qry_TL_Energie_Termine2_SummeNachTeam.Termine"
    Expression ="qry_TL_Energie_Vertrag2_SummeNachTeam.Verträge"
    Expression ="qry_TL_Energie_KundeStorno2_SummeNachTeam.[Storno Kunde]"
    Alias ="Abschlussquote"
    Expression ="IIf([Verträge] Is Not Null,[Verträge]/[Termine],0)"
    Alias ="Storno Kunde Quote"
    Expression ="IIf([Storno Kunde] Is Not Null,[Storno Kunde]/[Verträge],0)"
    Alias ="Bonus Staffel 1"
    Expression ="12"
    Alias ="Abschluss Staffel 1"
    Expression ="0.15"
    Alias ="Storno Kunde Staffel 1"
    Expression ="0.3"
    Alias ="Bonus Staffel 2"
    Expression ="20"
    Alias ="Abschluss Staffel 2"
    Expression ="0.18"
    Alias ="Storno Kunde Staffel 2"
    Expression ="0.25"
    Alias ="Bonus Staffel 3"
    Expression ="25"
    Alias ="Abschluss Staffel 3"
    Expression ="0.2"
    Alias ="Storno Kunde Staffel 3"
    Expression ="0.2"
    Alias ="Bonus Staffel 4"
    Expression ="30"
    Alias ="Abschluss Staffel 4"
    Expression ="0.25"
    Alias ="Storno Kunde Staffel 4"
    Expression ="0.2"
    Alias ="Abschluss Staffel Ist"
    Expression ="IIf([Abschlussquote]>=[Abschluss Staffel 4],4,IIf([Abschlussquote]>=[Abschluss S"
        "taffel 3],3,IIf([Abschlussquote]>=[Abschluss Staffel 2],2,IIf([Abschlussquote]>="
        "[Abschluss Staffel 1],1,0))))"
    Alias ="Storno Kunde Staffel Ist"
    Expression ="IIf([Storno Kunde Quote]<=[Storno Kunde Staffel 4],4,IIf([Storno Kunde Quote]<=["
        "Storno Kunde Staffel 3],3,IIf([Storno Kunde Quote]<=[Storno Kunde Staffel 2],2,I"
        "If([Storno Kunde Quote]<=[Storno Kunde Staffel 1],1,0))))"
    Alias ="Staffel Ist"
    Expression ="IIf([Abschluss Staffel Ist]<[Storno Kunde Staffel Ist],[Abschluss Staffel Ist],["
        "Storno Kunde Staffel Ist])"
End
Begin Joins
    LeftTable ="qry_TL_Energie_Termine2_SummeNachTeam"
    RightTable ="qry_TL_Energie_Vertrag2_SummeNachTeam"
    Expression ="qry_TL_Energie_Termine2_SummeNachTeam.name_vet = qry_TL_Energie_Vertrag2_SummeNa"
        "chTeam.name_vet"
    Flag =2
    LeftTable ="qry_TL_Energie_Termine2_SummeNachTeam"
    RightTable ="qry_TL_Energie_KundeStorno2_SummeNachTeam"
    Expression ="qry_TL_Energie_Termine2_SummeNachTeam.name_vet = qry_TL_Energie_KundeStorno2_Sum"
        "meNachTeam.name_vet"
    Flag =2
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="Abschlussquote"
        dbText "Format" ="Percent"
        dbInteger "ColumnWidth" ="1575"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Storno Kunde Quote"
        dbText "Format" ="Percent"
        dbInteger "ColumnWidth" ="1950"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_TL_Energie_Vertrag2_SummeNachTeam.Verträge"
        dbInteger "ColumnWidth" ="915"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_TL_Energie_KundeStorno2_SummeNachTeam.[Storno Kunde]"
        dbInteger "ColumnWidth" ="1365"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Abschluss Staffel 1"
        dbInteger "ColumnWidth" ="1860"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Abschluss Staffel Ist"
        dbInteger "ColumnWidth" ="1965"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Storno Kunde Staffel Ist"
        dbInteger "ColumnWidth" ="2235"
        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 =539
    Begin
        Left =38
        Top =6
        Right =134
        Bottom =100
        Top =0
        Name ="qry_TL_Energie_Termine2_SummeNachTeam"
        Name =""
    End
    Begin
        Left =493
        Top =3
        Right =589
        Bottom =97
        Top =0
        Name ="qry_TL_Energie_Vertrag2_SummeNachTeam"
        Name =""
    End
    Begin
        Left =875
        Top =5
        Right =971
        Bottom =99
        Top =0
        Name ="qry_TL_Energie_KundeStorno2_SummeNachTeam"
        Name =""
    End
End
