Operation =1
Option =0
Where ="(((tbl_agent.Position)=\"Agent\"))"
Begin InputTables
    Name ="qry_AnmeldungDatenbankAgenten"
    Name ="tbl_agent"
    Name ="qry_TermineAgentenZeitkontrolle2"
    Name ="qry_LetzterStatus"
End
Begin OutputColumns
    Expression ="qry_AnmeldungDatenbankAgenten.Mitarbeiter"
    Expression ="qry_AnmeldungDatenbankAgenten.Datum"
    Expression ="qry_AnmeldungDatenbankAgenten.MinvonUhrzeit"
    Expression ="qry_LetzterStatus.MaxvonUhrzeit"
    Alias ="Arbeitszeit brutto"
    Expression ="[MaxvonUhrzeit]-[MinvonUhrzeit]"
    Alias ="Arbeitszeit abzgl Pause"
    Expression ="[Arbeitszeit brutto]-#12/30/1899 1:0:0#"
    Alias ="Arbeitszeit decimal"
    Expression ="[Arbeitszeit abzgl Pause]*24"
    Expression ="qry_TermineAgentenZeitkontrolle2.[Anzahl Termine brutto ohne Backoffice]"
    Alias ="Termine / Stunde"
    Expression ="[Anzahl Termine brutto ohne Backoffice]/[Arbeitszeit decimal]"
    Expression ="tbl_agent.Office"
    Expression ="tbl_agent.Position"
End
Begin Joins
    LeftTable ="qry_AnmeldungDatenbankAgenten"
    RightTable ="qry_LetzterStatus"
    Expression ="qry_AnmeldungDatenbankAgenten.Mitarbeiter = qry_LetzterStatus.Terminierer"
    Flag =1
    LeftTable ="qry_AnmeldungDatenbankAgenten"
    RightTable ="qry_LetzterStatus"
    Expression ="qry_AnmeldungDatenbankAgenten.Datum = qry_LetzterStatus.Anruftag"
    Flag =1
    LeftTable ="qry_LetzterStatus"
    RightTable ="qry_TermineAgentenZeitkontrolle2"
    Expression ="qry_LetzterStatus.Terminierer = qry_TermineAgentenZeitkontrolle2.Terminierer"
    Flag =2
    LeftTable ="qry_LetzterStatus"
    RightTable ="qry_TermineAgentenZeitkontrolle2"
    Expression ="qry_LetzterStatus.Anruftag = qry_TermineAgentenZeitkontrolle2.Anruftag"
    Flag =2
    LeftTable ="qry_LetzterStatus"
    RightTable ="tbl_agent"
    Expression ="qry_LetzterStatus.Terminierer = tbl_agent.Agent"
    Flag =1
End
Begin OrderBy
    Expression ="qry_AnmeldungDatenbankAgenten.Mitarbeiter"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="Arbeitszeit brutto"
        dbInteger "ColumnWidth" ="1950"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Short Time"
    End
    Begin
        dbText "Name" ="Arbeitszeit abzgl Pause"
        dbInteger "ColumnWidth" ="2250"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Short Time"
    End
    Begin
        dbText "Name" ="Termine / Stunde"
        dbInteger "ColumnWidth" ="2280"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Standard"
        dbByte "DecimalPlaces" ="1"
    End
    Begin
        dbText "Name" ="qry_AnmeldungDatenbankAgenten.Mitarbeiter"
        dbInteger "ColumnWidth" ="2865"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Arbeitszeit decimal"
        dbInteger "ColumnWidth" ="1845"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Standard"
        dbByte "DecimalPlaces" ="1"
    End
    Begin
        dbText "Name" ="qry_LetzterStatus.MaxvonUhrzeit"
        dbText "Format" ="Short Time"
    End
    Begin
        dbText "Name" ="qry_AnmeldungDatenbankAgenten.MinvonUhrzeit"
        dbText "Format" ="Short Time"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =2560
    Bottom =1243
    Left =-1
    Top =-1
    Right =2553
    Bottom =558
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =3
        Right =380
        Bottom =87
        Top =0
        Name ="qry_AnmeldungDatenbankAgenten"
        Name =""
    End
    Begin
        Left =839
        Top =6
        Right =935
        Bottom =120
        Top =0
        Name ="tbl_agent"
        Name =""
    End
    Begin
        Left =973
        Top =6
        Right =1513
        Bottom =105
        Top =0
        Name ="qry_TermineAgentenZeitkontrolle2"
        Name =""
    End
    Begin
        Left =1794
        Top =250
        Right =1890
        Bottom =364
        Top =0
        Name ="qry_LetzterStatus"
        Name =""
    End
End
