Operation =1
Option =0
Begin InputTables
    Name ="qry_Solarcheck2_Termine_MonatJahr_AD"
    Name ="qry_Solarcheck2_Abschluesse_MonatJahr_AD"
    Name ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD"
    Name ="tbl_ad"
    Name ="tbl_verkaufteam_vet"
    Name ="qry_ADTL"
    Name ="qry_ADRL"
    Name ="tbl_mepfirma"
End
Begin OutputColumns
    Alias ="B Nummer"
    Expression ="\"B\" & [mep_personal_id]"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.AD"
    Expression ="tbl_mepfirma.name_mef"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.[Monat Jahr]"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.Termine"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD.Vertragseingang"
    Alias ="Vertragseingang %"
    Expression ="IIf([Vertragseingang]>0,[Vertragseingang]/[Termine],0)"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD.[Storno Kunde]"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD.KW"
    Expression ="tbl_verkaufteam_vet.id_verkaufteam"
    Expression ="tbl_verkaufteam_vet.name_vet"
    Expression ="tbl_verkaufteam_vet.idad_teamleiter"
    Expression ="tbl_verkaufteam_vet.idad_regionalleiter"
    Expression ="tbl_verkaufteam_vet.idmepfirma"
    Expression ="qry_ADTL.Teamleiter"
    Expression ="qry_ADRL.Regionalleiter"
    Expression ="qry_Solarcheck2_Abschluesse_MonatJahr_AD.[Anzahl Anschluss]"
    Alias ="Quote"
    Expression ="IIf([Anzahl Anschluss] Is Not Null,[Anzahl Anschluss]/[Termine],0)"
End
Begin Joins
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD"
    RightTable ="qry_Solarcheck2_Abschluesse_MonatJahr_AD"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.AD = qry_Solarcheck2_Abschluesse_MonatJahr_"
        "AD.AD"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD"
    RightTable ="qry_Solarcheck2_Abschluesse_MonatJahr_AD"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.[Monat Jahr] = qry_Solarcheck2_Abschluesse_"
        "MonatJahr_AD.[Monat Jahr]"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD"
    RightTable ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.AD = qry_Solarcheck5_VertraegeSST_MonatJAhr"
        "_AD.AD"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD"
    RightTable ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.[Monat Jahr] = qry_Solarcheck5_VertraegeSST"
        "_MonatJAhr_AD.[Monat Jahr]"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD"
    RightTable ="tbl_ad"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.AD = tbl_ad.AD"
    Flag =1
    LeftTable ="tbl_ad"
    RightTable ="tbl_verkaufteam_vet"
    Expression ="tbl_ad.id_verkaufteam = tbl_verkaufteam_vet.id_verkaufteam"
    Flag =1
    LeftTable ="tbl_verkaufteam_vet"
    RightTable ="qry_ADTL"
    Expression ="tbl_verkaufteam_vet.idad_teamleiter = qry_ADTL.ID"
    Flag =1
    LeftTable ="tbl_verkaufteam_vet"
    RightTable ="qry_ADRL"
    Expression ="tbl_verkaufteam_vet.idad_regionalleiter = qry_ADRL.ID"
    Flag =1
    LeftTable ="tbl_ad"
    RightTable ="tbl_mepfirma"
    Expression ="tbl_ad.id_mepfirma = tbl_mepfirma.id_mepfirma"
    Flag =1
End
Begin OrderBy
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD.[Monat Jahr]"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="Quote"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
    End
    Begin
        dbText "Name" ="Vertragseingang %"
        dbInteger "ColumnWidth" ="1830"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="2"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Abschluesse_MonatJahr_AD.[Anzahl Anschluss]"
        dbInteger "ColumnWidth" ="1755"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_AD.AD"
        dbInteger "ColumnWidth" ="2160"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_AD.Termine"
        dbInteger "ColumnWidth" ="870"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD.KW"
        dbInteger "ColumnWidth" ="765"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_verkaufteam_vet.idad_teamleiter"
        dbInteger "ColumnWidth" ="1500"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_verkaufteam_vet.idad_regionalleiter"
        dbInteger "ColumnWidth" ="1740"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_verkaufteam_vet.idmepfirma"
        dbInteger "ColumnWidth" ="1125"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_ADTL.Teamleiter"
        dbInteger "ColumnWidth" ="1815"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_ADRL.Regionalleiter"
        dbInteger "ColumnWidth" ="2310"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_verkaufteam_vet.name_vet"
        dbInteger "ColumnWidth" ="3435"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =3440
    Bottom =1241
    Left =-1
    Top =-1
    Right =3433
    Bottom =417
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =219
        Top =24
        Right =777
        Bottom =123
        Top =0
        Name ="qry_Solarcheck2_Termine_MonatJahr_AD"
        Name =""
    End
    Begin
        Left =500
        Top =142
        Right =596
        Bottom =241
        Top =0
        Name ="qry_Solarcheck2_Abschluesse_MonatJahr_AD"
        Name =""
    End
    Begin
        Left =751
        Top =224
        Right =847
        Bottom =338
        Top =0
        Name ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD"
        Name =""
    End
    Begin
        Left =986
        Top =33
        Right =1122
        Bottom =147
        Top =37
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =1279
        Top =55
        Right =1505
        Bottom =169
        Top =1
        Name ="tbl_verkaufteam_vet"
        Name =""
    End
    Begin
        Left =1851
        Top =103
        Right =2164
        Bottom =202
        Top =1
        Name ="qry_ADTL"
        Name =""
    End
    Begin
        Left =1696
        Top =211
        Right =2203
        Bottom =325
        Top =0
        Name ="qry_ADRL"
        Name =""
    End
    Begin
        Left =1487
        Top =251
        Right =1583
        Bottom =335
        Top =0
        Name ="tbl_mepfirma"
        Name =""
    End
End
