Operation =1
Option =0
Where ="(((tbl_ad.AD) Not Like \"*Admin*\" And (tbl_ad.AD) Not Like \"Reise*\" And (tbl_"
    "ad.AD) Not Like \"Solar*\") AND ((tbl_ad.ist_taetig)=1) AND ((tbl_ad.verkaeufert"
    "yp)=2)) OR (((tbl_ad.AD) Not Like \"*Admin*\" And (tbl_ad.AD) Not Like \"Reise*\""
    " And (tbl_ad.AD) Not Like \"Solar*\") AND ((tbl_ad.ist_taetig)=0) AND ((tbl_ad.t"
    "aetig_bis)>#3/1/2018#) AND ((tbl_ad.verkaeufertyp)=2)) OR (((tbl_ad.AD)=\"H. Mie"
    "tzschke\")) OR (((tbl_ad.AD)=\"B. Beyer\")) OR (((tbl_ad.AD)=\"Re. Humann\"))"
Begin InputTables
    Name ="tbl_ad"
    Name ="tbl_mepfirma"
End
Begin OutputColumns
    Alias ="AD Melcom"
    Expression ="[Name] & \", \" & [Vorname]"
    Expression ="tbl_ad.AD"
    Alias ="Firma"
    Expression ="\"\""
    Expression ="tbl_ad.Anrede"
    Expression ="tbl_ad.Vorname"
    Expression ="tbl_ad.Name"
    Expression ="tbl_ad.StrasseHsNrAd"
    Expression ="tbl_ad.PlzAd"
    Expression ="tbl_ad.OrtAd"
    Expression ="tbl_ad.RufnummerMOBIL"
    Expression ="tbl_ad.Email"
    Expression ="tbl_ad.ist_taetig"
    Expression ="tbl_ad.taetig_von"
    Expression ="tbl_ad.taetig_bis"
    Alias ="Unit Alt"
    Expression ="tbl_mepfirma.name_mef"
    Alias ="Angestellt oder HV Alt"
    Expression ="IIf([Id_Firma_mep]=25 Or [Id_Firma_mep]=64,\"HV\",\"Angestellt\")"
    Alias ="Id_Firma_mep"
    Expression ="tbl_ad.id_mepfirma"
    Expression ="tbl_ad.verkaeufertyp"
End
Begin Joins
    LeftTable ="tbl_ad"
    RightTable ="tbl_mepfirma"
    Expression ="tbl_ad.id_mepfirma = tbl_mepfirma.id_mepfirma"
    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 =-25
    Right =3440
    Bottom =1220
    Left =-1
    Top =-1
    Right =3437
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =217
        Bottom =115
        Top =9
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =376
        Top =26
        Right =472
        Bottom =105
        Top =0
        Name ="tbl_mepfirma"
        Name =""
    End
End
