Operation =1
Option =0
Where ="(((tbl_simtl.Aktivierungsdatum) Between #4/1/2017# And #4/30/2019#) AND ((tbl_na"
    "chrichtentl.NachrichtText)=\"OK\"))"
Having ="(((Count(tbl_simtl.AntragsID))>49))"
Begin InputTables
    Name ="tbl_simtl"
    Name ="tbl_nachrichtentl"
    Name ="tbl_statustabelle"
    Name ="tbl_kunden"
End
Begin OutputColumns
    Alias ="Monat Jahr Aktivierungsdatum"
    Expression ="Format([Aktivierungsdatum],\"YYYY-mm\")"
    Expression ="tbl_kunden.Firma"
    Alias ="Anzahl Karten"
    Expression ="Count(tbl_simtl.AntragsID)"
End
Begin Joins
    LeftTable ="tbl_simtl"
    RightTable ="tbl_statustabelle"
    Expression ="tbl_simtl.Status_NR = tbl_statustabelle.Status_NR"
    Flag =1
    LeftTable ="tbl_simtl"
    RightTable ="tbl_nachrichtentl"
    Expression ="tbl_simtl.AntragsID = tbl_nachrichtentl.AntragsID"
    Flag =1
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_kunden"
    Expression ="tbl_statustabelle.KD_NR = tbl_kunden.KD_NR"
    Flag =1
End
Begin Groups
    Expression ="Format([Aktivierungsdatum],\"YYYY-mm\")"
    GroupLevel =0
    Expression ="tbl_kunden.Firma"
    GroupLevel =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="tbl_kunden.Firma"
        dbInteger "ColumnWidth" ="5565"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Monat Jahr Aktivierungsdatum"
        dbInteger "ColumnWidth" ="2790"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Anzahl Karten"
        dbInteger "ColumnWidth" ="1920"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-27
    Right =3442
    Bottom =1222
    Left =-1
    Top =-1
    Right =3437
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =543
    Begin
        Left =38
        Top =6
        Right =134
        Bottom =115
        Top =60
        Name ="tbl_simtl"
        Name =""
    End
    Begin
        Left =429
        Top =5
        Right =525
        Bottom =114
        Top =3
        Name ="tbl_nachrichtentl"
        Name =""
    End
    Begin
        Left =870
        Top =15
        Right =966
        Bottom =124
        Top =0
        Name ="tbl_statustabelle"
        Name =""
    End
    Begin
        Left =1155
        Top =21
        Right =1251
        Bottom =130
        Top =2
        Name ="tbl_kunden"
        Name =""
    End
End
