Operation =1
Option =0
Where ="(((tbl_agent.Benutzerart)=4))"
Begin InputTables
    Name ="qry_Ana_VVL_2018_4_Endstatus2__"
    Name ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__"
    Name ="qry_Ana_VVL_2018_5_AktiveWV2__"
    Name ="tbl_agent"
End
Begin OutputColumns
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[Monat Jahr]"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.Terminierer"
    Alias ="Endstatus gesamt"
    Expression ="IIf([Anzahl Retention Kunden] Is Not Null,[Anzahl Retention Kunden],0)+IIf([TL R"
        "etention] Is Not Null,[TL Retention],0)+IIf([neR] Is Not Null,[neR],0)+IIf([x Ni"
        "e wieder anrufen] Is Not Null,[x Nie wieder anrufen],0)+IIf([KI Retention Altkos"
        "ten] Is Not Null,[KI Retention Altkosten],0)+IIf([KI Retention Smartphone Option"
        "] Is Not Null,[KI Retention Smartphone Option],0)+IIf([KI Retention kein Ansprec"
        "hpartner BCS] Is Not Null,[KI Retention kein Ansprechpartner BCS],0)+IIf([KI Ret"
        "ention zu teuer] Is Not Null,[KI Retention zu teuer],0)+IIf([KI Retention Nichtn"
        "utzung] Is Not Null,[KI Retention Nichtnutzung],0)"
    Expression ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__.[Anzahl Retention Kunden]"
    Alias ="% Retention"
    Expression ="IIf([Anzahl Retention Kunden] Is Not Null,[Anzahl Retention Kunden]/[Endstatus g"
        "esamt],0)"
    Expression ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__.[Anzahl Retention]"
    Expression ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__.[Anzahl Retention pro Kunde]"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[TL Retention]"
    Alias ="% TL Retention"
    Expression ="IIf([TL Retention] Is Not Null,[TL Retention]/[Endstatus gesamt],0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.neR"
    Alias ="% neR"
    Expression ="IIf([neR] Is Not Null,[neR]/[Endstatus gesamt],0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[x Nie wieder anrufen]"
    Alias ="% x Nie wieder anrufen"
    Expression ="IIf([x Nie wieder anrufen] Is Not Null,[x Nie wieder anrufen]/[Endstatus gesamt]"
        ",0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention Altkosten]"
    Alias ="% KI Retention Altkosten"
    Expression ="IIf([KI Retention Altkosten] Is Not Null,[KI Retention Altkosten]/[Endstatus ges"
        "amt],0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention Smartphone Option]"
    Alias ="% KI Retention Smartphone Option"
    Expression ="IIf([KI Retention Smartphone Option] Is Not Null,[KI Retention Smartphone Option"
        "]/[Endstatus gesamt],0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention kein Ansprechpartner BCS]"
    Alias ="% KI Retention kein Ansprechpartner BCS"
    Expression ="IIf([KI Retention kein Ansprechpartner BCS] Is Not Null,[KI Retention kein Anspr"
        "echpartner BCS]/[Endstatus gesamt],0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention zu teuer]"
    Alias ="% KI Retention zu teuer"
    Expression ="IIf([KI Retention zu teuer] Is Not Null,[KI Retention zu teuer]/[Endstatus gesam"
        "t],0)"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention Nichtnutzung]"
    Alias ="% KI Retention Nichtnutzung"
    Expression ="IIf([KI Retention Nichtnutzung] Is Not Null,[KI Retention Nichtnutzung]/[Endstat"
        "us gesamt],0)"
    Alias ="Aktive WV"
    Expression ="IIf([WVR] Is Not Null,[WVR],0)+IIf([WV Retention Angebot] Is Not Null,[WV Retent"
        "ion Angebot],0)+IIf([WV Retention Rekla] Is Not Null,[WV Retention Rekla],0)+IIf"
        "([WV Retention nicht erreicht] Is Not Null,[WV Retention nicht erreicht],0)+IIf("
        "[WV Retention Service] Is Not Null,[WV Retention Service],0)"
    Expression ="qry_Ana_VVL_2018_5_AktiveWV2__.WVR"
    Expression ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention Angebot]"
    Expression ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention Rekla]"
    Expression ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention nicht erreicht]"
    Expression ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention Service]"
    Expression ="tbl_agent.Benutzerart"
End
Begin Joins
    LeftTable ="qry_Ana_VVL_2018_4_Endstatus2__"
    RightTable ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[Monat Jahr] = qry_Ana_VVL_2018_Status2_Retentio"
        "n3_AnzahlKunden2__.[Monat Jahr]"
    Flag =2
    LeftTable ="qry_Ana_VVL_2018_4_Endstatus2__"
    RightTable ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.Terminierer = qry_Ana_VVL_2018_Status2_Retention"
        "3_AnzahlKunden2__.Terminierer"
    Flag =2
    LeftTable ="qry_Ana_VVL_2018_4_Endstatus2__"
    RightTable ="qry_Ana_VVL_2018_5_AktiveWV2__"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.[Monat Jahr] = qry_Ana_VVL_2018_5_AktiveWV2__.[M"
        "onat Jahr]"
    Flag =2
    LeftTable ="qry_Ana_VVL_2018_4_Endstatus2__"
    RightTable ="qry_Ana_VVL_2018_5_AktiveWV2__"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.Terminierer = qry_Ana_VVL_2018_5_AktiveWV2__.Ter"
        "minierer"
    Flag =2
    LeftTable ="qry_Ana_VVL_2018_4_Endstatus2__"
    RightTable ="tbl_agent"
    Expression ="qry_Ana_VVL_2018_4_Endstatus2__.Terminierer = tbl_agent.Agent"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.Terminierer"
        dbInteger "ColumnWidth" ="2070"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.neR"
        dbInteger "ColumnWidth" ="525"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.[x Nie wieder anrufen]"
        dbInteger "ColumnWidth" ="1935"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention Altkosten]"
        dbInteger "ColumnWidth" ="2130"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention Nichtnutzung]"
        dbInteger "ColumnWidth" ="2445"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention Smartphone Option]"
        dbInteger "ColumnWidth" ="2985"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention kein Ansprechpartner BCS]"
        dbInteger "ColumnWidth" ="3615"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_4_Endstatus2__.[KI Retention zu teuer]"
        dbInteger "ColumnWidth" ="2010"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention Angebot]"
        dbInteger "ColumnWidth" ="2175"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention Rekla]"
        dbInteger "ColumnWidth" ="1950"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Ana_VVL_2018_5_AktiveWV2__.[WV Retention nicht erreicht]"
        dbInteger "ColumnWidth" ="2580"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Endstatus gesamt"
        dbInteger "ColumnWidth" ="1770"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% Retention"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
    End
    Begin
        dbText "Name" ="% TL Retention"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="1515"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% neR"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
    End
    Begin
        dbText "Name" ="% x Nie wieder anrufen"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="2175"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% KI Retention Altkosten"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="2370"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% KI Retention Smartphone Option"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="3225"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% KI Retention kein Ansprechpartner BCS"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="3855"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% KI Retention zu teuer"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="2250"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="% KI Retention Nichtnutzung"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="2685"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-27
    Right =1922
    Bottom =956
    Left =-1
    Top =-1
    Right =1913
    Bottom =145
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =134
        Bottom =115
        Top =0
        Name ="qry_Ana_VVL_2018_4_Endstatus2__"
        Name =""
    End
    Begin
        Left =351
        Top =3
        Right =582
        Bottom =112
        Top =2
        Name ="qry_Ana_VVL_2018_Status2_Retention3_AnzahlKunden2__"
        Name =""
    End
    Begin
        Left =874
        Top =8
        Right =970
        Bottom =117
        Top =3
        Name ="qry_Ana_VVL_2018_5_AktiveWV2__"
        Name =""
    End
    Begin
        Left =1213
        Top =14
        Right =1309
        Bottom =123
        Top =4
        Name ="tbl_agent"
        Name =""
    End
End
