Operation =1
Option =0
Begin InputTables
    Name ="qry_LohnabrechnungAgenten2"
    Name ="qry_LohnabrechnungAgenten4"
    Name ="qry_LohnabrechnungAgenten6"
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_LohnabrechnungAgenten6.[Kunden Abschluss]"
    Expression ="qry_LohnabrechnungAgenten6.Verträge"
    Expression ="qry_LohnabrechnungAgenten4.[-1]"
    Expression ="qry_LohnabrechnungAgenten4.[0]"
End
Begin Joins
    LeftTable ="qry_LohnabrechnungAgenten2"
    RightTable ="qry_LohnabrechnungAgenten4"
    Expression ="qry_LohnabrechnungAgenten2.Agent = qry_LohnabrechnungAgenten4.[Aktiver Agent]"
    Flag =1
    LeftTable ="qry_LohnabrechnungAgenten2"
    RightTable ="qry_LohnabrechnungAgenten6"
    Expression ="qry_LohnabrechnungAgenten2.Agent = qry_LohnabrechnungAgenten6.Terminierer"
    Flag =2
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbMemo "Filter" ="((EXAgentenStundenUndBonusAusgabeNeu.Agent=\"Alexander Schlager\"))"
Begin
    Begin
        dbText "Name" ="qry_LohnabrechnungAgenten6.[Kunden Abschluss]"
        dbInteger "ColumnWidth" ="1815"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_LohnabrechnungAgenten6.Verträge"
        dbInteger "ColumnWidth" ="915"
        dbBoolean "ColumnHidden" ="0"
    End
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 =134
        Bottom =115
        Top =0
        Name ="qry_LohnabrechnungAgenten2"
        Name =""
    End
    Begin
        Left =278
        Top =12
        Right =671
        Bottom =121
        Top =3
        Name ="qry_LohnabrechnungAgenten4"
        Name =""
    End
    Begin
        Left =989
        Top =13
        Right =1085
        Bottom =107
        Top =0
        Name ="qry_LohnabrechnungAgenten6"
        Name =""
    End
End
