openaccess/test/source/queries/r_TabRecapEFD.bas

Operation =1
Option =0
Where ="(((tbl_FormDep.Distance2_perso)<>0)) OR (((tbl_FormDep.Distance2_service)<>0)) O"
    "R (((tbl_FormDep.Distance1_perso)<>0)) OR (((tbl_FormDep.Repas)<>0))"
Begin InputTables
    Name ="tbl_FormDep"
    Name ="r_Agents"
End
Begin OutputColumns
    Expression ="tbl_FormDep.CodeAgent"
    Expression ="r_Agents.Nom"
    Expression ="tbl_FormDep.JourRH"
    Expression ="tbl_FormDep.MoisRH"
    Expression ="tbl_FormDep.AnneeRH"
    Alias ="DateRH"
    Expression ="CDate([JourRH] & \"/\" & [MoisRH] & \"/\" & [AnneeRH])"
    Expression ="tbl_FormDep.Itineraire"
    Expression ="tbl_FormDep.Distance2_perso"
    Expression ="tbl_FormDep.Distance2_service"
    Expression ="tbl_FormDep.Distance1_perso"
    Expression ="tbl_FormDep.Repas"
    Alias ="Vehicule"
    Expression ="IIf(([Distance2_perso]+[Distance1_perso])>0,'VP',IIf([Distance2_service]>0,'VS',"
        "''))"
    Expression ="tbl_FormDep.Remarque"
End
Begin Joins
    LeftTable ="r_Agents"
    RightTable ="tbl_FormDep"
    Expression ="r_Agents.CodeAgent = tbl_FormDep.CodeAgent"
    Flag =1
End
Begin OrderBy
    Expression ="r_Agents.Nom"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbBoolean "TotalsRow" ="0"
Begin
    Begin
        dbText "Name" ="tbl_FormDep.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DateRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.JourRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Nom"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.Remarque"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.Itineraire"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.Distance2_perso"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.Distance2_service"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.Distance1_perso"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.Repas"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Vehicule"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_Agents.Nom"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =956
    Bottom =545
    Left =-1
    Top =-1
    Right =940
    Bottom =287
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =270
        Top =12
        Right =512
        Bottom =291
        Top =0
        Name ="tbl_FormDep"
        Name =""
    End
    Begin
        Left =52
        Top =23
        Right =242
        Bottom =297
        Top =0
        Name ="r_Agents"
        Name =""
    End
End