Operation =1
Option =0
Begin InputTables
    Name ="qry_LohnabrechnungAgenten2"
    Name ="qry_LohnabrechnungAgenten4"
End
Begin OutputColumns
    Expression ="qry_LohnabrechnungAgenten2.Agent"
    Expression ="qry_LohnabrechnungAgenten2.Arbeitgeber"
    Expression ="qry_LohnabrechnungAgenten2.Office"
    Expression ="qry_LohnabrechnungAgenten2.Stundenlohn"
    Expression ="qry_LohnabrechnungAgenten2.[Stunden dezimal]"
    Alias ="Gehalt über Stundenlohn"
    Expression ="[Stundenlohn]*[Stunden dezimal]"
    Alias ="Stunden Zeitraum"
    Expression ="\"Von \" & [Formulare]![frmAnalyse]![VonLE] & \" bis \" & [Formulare]![frmAnalys"
        "e]![BisLE]"
    Expression ="qry_LohnabrechnungAgenten4.Netto"
    Expression ="qry_LohnabrechnungAgenten4.Brutto"
    Alias ="Netto pro Stunde"
    Expression ="[Netto]/[Stunden dezimal]"
    Alias ="Brutto pro Stunde"
    Expression ="[Brutto]/[Stunden dezimal]"
    Alias ="Stufe1 netto Termine"
    Expression ="51"
    Alias ="Stufe1 Bonus"
    Expression ="150"
    Alias ="Stufe2 netto Termine"
    Expression ="63"
    Alias ="Stufe2 Bonus"
    Expression ="250"
    Alias ="Stufe3 netto Termine"
    Expression ="80"
    Alias ="Stufe3 Bonus"
    Expression ="500"
    Alias ="Stufe4 netto Termine"
    Expression ="97"
    Alias ="Stufe4 Bonus"
    Expression ="1000"
    Alias ="Bonus Netto Termine"
    Expression ="IIf([Netto]>=[Stufe4 netto Termine],[Stufe4 Bonus],IIf([Netto]>=[Stufe3 netto Te"
        "rmine],[Stufe3 Bonus],IIf([Netto]>=[Stufe2 netto Termine] And [Netto]<[Stufe3 ne"
        "tto Termine],[Stufe2 Bonus],IIf([Netto]>=[Stufe1 netto Termine] And [Netto]<[Stu"
        "fe2 netto Termine],[Stufe1 Bonus],0))))"
    Alias ="Termindatum Zeitraum"
    Expression ="\"Von \" & [Formulare]![frmAnalyse]![Von] & \" bis \" & [Formulare]![frmAnalyse]"
        "![Bis]"
    Expression ="qry_LohnabrechnungAgenten2.Arbeitstage"
    Expression ="qry_LohnabrechnungAgenten4.[Kunden Abschluss]"
    Expression ="qry_LohnabrechnungAgenten4.Verträge"
End
Begin Joins
    LeftTable ="qry_LohnabrechnungAgenten2"
    RightTable ="qry_LohnabrechnungAgenten4"
    Expression ="qry_LohnabrechnungAgenten2.Agent = qry_LohnabrechnungAgenten4.[Aktiver Agent]"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="Netto pro Stunde"
        dbText "Format" ="Standard"
        dbInteger "ColumnWidth" ="1650"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Brutto pro Stunde"
        dbText "Format" ="Standard"
        dbInteger "ColumnWidth" ="1710"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Gehalt über Stundenlohn"
        dbInteger "ColumnWidth" ="2325"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Stufe1 netto Termine"
        dbInteger "ColumnWidth" ="1980"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Bonus Netto Termine"
        dbInteger "ColumnWidth" ="2010"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Stunden Zeitraum"
        dbInteger "ColumnWidth" ="2880"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Termindatum Zeitraum"
        dbInteger "ColumnWidth" ="2880"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_LohnabrechnungAgenten2.Arbeitgeber"
        dbInteger "ColumnWidth" ="2475"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_LohnabrechnungAgenten4.[Kunden Abschluss]"
        dbInteger "ColumnWidth" ="1815"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-25
    Right =3440
    Bottom =1220
    Left =-1
    Top =-1
    Right =3437
    Bottom =605
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =-1365
        Top =6
        Right =-1269
        Bottom =115
        Top =0
        Name ="qry_LohnabrechnungAgenten2"
        Name =""
    End
    Begin
        Left =-943
        Top =1
        Right =-847
        Bottom =95
        Top =0
        Name ="qry_LohnabrechnungAgenten4"
        Name =""
    End
End
