Operation =1
Option =0
Begin InputTables
    Name ="qry_MepBPADAuswertung"
    Name ="tbl_ad"
    Name ="tbl_verkaufteam_vet"
    Name ="qry_ADTL"
    Name ="qry_ADRL"
    Name ="tbl_mepfirma"
End
Begin OutputColumns
    Expression ="qry_MepBPADAuswertung.Faktor"
    Alias ="Verkäufer"
    Expression ="qry_MepBPADAuswertung.AD"
    Expression ="qry_MepBPADAuswertung.[Anzahl Termine an AD]"
    Expression ="qry_MepBPADAuswertung.[Anzahl Vertragseingang]"
    Expression ="qry_MepBPADAuswertung.[Abschlußquote %]"
    Expression ="qry_MepBPADAuswertung.[Storno Kunde]"
    Expression ="qry_MepBPADAuswertung.[Storno Kunde %]"
    Expression ="qry_MepBPADAuswertung.[Storno MEP]"
    Expression ="qry_MepBPADAuswertung.[Storno MEP %]"
    Expression ="qry_MepBPADAuswertung.KWp"
    Expression ="qry_MepBPADAuswertung.[KWp Mittelwert]"
    Alias ="TL"
    Expression ="IIf([TL1] Is Not Null,[TL1],[Verkäufer])"
    Alias ="TL1"
    Expression ="qry_ADTL.Teamleiter"
    Expression ="qry_MepBPADAuswertung.[Anzahl Abschluesse]"
    Expression ="qry_MepBPADAuswertung.[Abschlußquote Abschlüsse %]"
End
Begin Joins
    LeftTable ="qry_MepBPADAuswertung"
    RightTable ="tbl_ad"
    Expression ="qry_MepBPADAuswertung.AD = tbl_ad.AD"
    Flag =2
    LeftTable ="tbl_ad"
    RightTable ="tbl_verkaufteam_vet"
    Expression ="tbl_ad.id_verkaufteam = tbl_verkaufteam_vet.id_verkaufteam"
    Flag =2
    LeftTable ="tbl_verkaufteam_vet"
    RightTable ="qry_ADTL"
    Expression ="tbl_verkaufteam_vet.idad_teamleiter = qry_ADTL.ID"
    Flag =2
    LeftTable ="tbl_verkaufteam_vet"
    RightTable ="qry_ADRL"
    Expression ="tbl_verkaufteam_vet.idad_regionalleiter = qry_ADRL.ID"
    Flag =2
    LeftTable ="tbl_verkaufteam_vet"
    RightTable ="tbl_mepfirma"
    Expression ="tbl_verkaufteam_vet.idmepfirma = tbl_mepfirma.id_mepfirma"
    Flag =2
End
Begin OrderBy
    Expression ="qry_MepBPADAuswertung.Faktor"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =1920
    Bottom =881
    Left =-1
    Top =-1
    Right =1913
    Bottom =307
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =42
        Top =139
        Right =405
        Bottom =268
        Top =8
        Name ="qry_MepBPADAuswertung"
        Name =""
    End
    Begin
        Left =253
        Top =7
        Right =349
        Bottom =121
        Top =39
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =433
        Top =11
        Right =650
        Bottom =140
        Top =0
        Name ="tbl_verkaufteam_vet"
        Name =""
    End
    Begin
        Left =761
        Top =24
        Right =922
        Bottom =138
        Top =0
        Name ="qry_ADTL"
        Name =""
    End
    Begin
        Left =1050
        Top =40
        Right =1146
        Bottom =154
        Top =0
        Name ="qry_ADRL"
        Name =""
    End
    Begin
        Left =710
        Top =137
        Right =806
        Bottom =221
        Top =0
        Name ="tbl_mepfirma"
        Name =""
    End
End
