Operation =1
Option =0
Where ="(((tbl_ad.AD) Not Like \"Solar*\" And (tbl_ad.AD) Not Like \"*SV*\" And (tbl_ad."
    "AD) Not Like \"Reise*\" And (tbl_ad.AD)<>\"Benjamin Beyer Admin\") AND ((tbl_ad."
    "ist_taetig)=1) AND ((verkaeufertyp.id_verkaeufertyp)=2))"
Begin InputTables
    Name ="tbl_ad"
    Name ="tbl_mepfirma"
    Name ="verkaeufertyp"
End
Begin OutputColumns
    Expression ="tbl_ad.AD"
    Expression ="tbl_mepfirma.name_mef"
    Expression ="verkaeufertyp.bezeichnung"
    Expression ="tbl_ad.ist_taetig"
    Expression ="tbl_ad.taetig_von"
    Expression ="tbl_ad.Name"
    Expression ="tbl_ad.Vorname"
    Alias ="Name Melcom"
    Expression ="[Name] & \", \" & [Vorname]"
    Expression ="tbl_ad.Email"
    Expression ="tbl_ad.PlzAd"
    Expression ="tbl_ad.OrtAd"
    Expression ="tbl_ad.StrasseHsNrAd"
    Expression ="tbl_ad.adGeoLat"
    Expression ="tbl_ad.adGeoLng"
    Expression ="tbl_ad.RufnummerMOBIL"
End
Begin Joins
    LeftTable ="tbl_ad"
    RightTable ="tbl_mepfirma"
    Expression ="tbl_ad.id_mepfirma = tbl_mepfirma.id_mepfirma"
    Flag =1
    LeftTable ="tbl_ad"
    RightTable ="verkaeufertyp"
    Expression ="tbl_ad.verkaeufertyp = verkaeufertyp.id_verkaeufertyp"
    Flag =1
End
Begin OrderBy
    Expression ="tbl_mepfirma.name_mef"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbMemo "OrderBy" ="EXEnergieADnachFirma_DatenREXX.taetig_von"
Begin
    Begin
        dbText "Name" ="tbl_ad.AD"
        dbInteger "ColumnWidth" ="2160"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="verkaeufertyp.bezeichnung"
        dbInteger "ColumnWidth" ="1470"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Name Melcom"
        dbInteger "ColumnWidth" ="1980"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-25
    Right =1920
    Bottom =1006
    Left =-1
    Top =-1
    Right =1913
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =292
        Bottom =115
        Top =30
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =509
        Top =18
        Right =605
        Bottom =97
        Top =0
        Name ="tbl_mepfirma"
        Name =""
    End
    Begin
        Left =776
        Top =20
        Right =872
        Bottom =99
        Top =0
        Name ="verkaeufertyp"
        Name =""
    End
End
