Operation =1
Option =0
Begin InputTables
    Name ="tbl_ad"
    Name ="tbl_mepfirma"
    Name ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter"
    Name ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL"
End
Begin OutputColumns
    Alias ="B Nummer"
    Expression ="\"B\" & [mep_personal_id]"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.AD"
    Expression ="tbl_mepfirma.name_mef"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.[Monat Jahr]"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.Termine"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL.Vertragseingang"
    Alias ="Vertragseingang %"
    Expression ="IIf([Vertragseingang]>0,[Vertragseingang]/[Termine],0)"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL.[Storno Kunde]"
    Alias ="Storno %"
    Expression ="IIf([Storno Kunde]>0,[Storno Kunde]/[Vertragseingang],0)"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL.KW"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL.[KW provisionsfähig]"
End
Begin Joins
    LeftTable ="tbl_ad"
    RightTable ="tbl_mepfirma"
    Expression ="tbl_ad.id_mepfirma = tbl_mepfirma.id_mepfirma"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter"
    RightTable ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.AD = qry_Solarcheck5_VertraegeSS"
        "T_MonatJAhr_AD_TL.AD"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter"
    RightTable ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.[Monat Jahr] = qry_Solarcheck5_V"
        "ertraegeSST_MonatJAhr_AD_TL.[Monat Jahr]"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter"
    RightTable ="tbl_ad"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.AD = tbl_ad.AD"
    Flag =2
End
Begin OrderBy
    Expression ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.[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" ="Vertragseingang %"
        dbInteger "ColumnWidth" ="1830"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="2"
    End
    Begin
        dbText "Name" ="Storno %"
        dbInteger "ColumnWidth" ="1830"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="2"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.AD"
        dbInteger "ColumnWidth" ="2160"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter.Termine"
        dbInteger "ColumnWidth" ="870"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL.KW"
        dbInteger "ColumnWidth" ="765"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =3442
    Bottom =1243
    Left =-1
    Top =-1
    Right =3437
    Bottom =417
    Left =420
    Top =0
    ColumnsShown =539
    Begin
        Left =868
        Top =219
        Right =1004
        Bottom =333
        Top =37
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =1141
        Top =279
        Right =1237
        Bottom =363
        Top =0
        Name ="tbl_mepfirma"
        Name =""
    End
    Begin
        Left =406
        Top =42
        Right =502
        Bottom =141
        Top =0
        Name ="qry_Solarcheck2_Termine_MonatJahr_AD_Teamleiter"
        Name =""
    End
    Begin
        Left =897
        Top =27
        Right =1518
        Bottom =141
        Top =0
        Name ="qry_Solarcheck5_VertraegeSST_MonatJAhr_AD_TL"
        Name =""
    End
End
