openaccess/test/source/queries/r_NbJoursImport.bas

Operation =1
Option =0
Begin InputTables
    Name ="tbl_ImportRH"
End
Begin OutputColumns
    Expression ="tbl_ImportRH.CodeAgent"
    Expression ="tbl_ImportRH.DateRH"
    Alias ="CompteDeCodeLigne"
    Expression ="Count(tbl_ImportRH.CodeLigne)"
    Alias ="moisRH"
    Expression ="Month([dateRH])"
    Alias ="anneeRH"
    Expression ="Year([dateRH])"
End
Begin Groups
    Expression ="tbl_ImportRH.CodeAgent"
    GroupLevel =0
    Expression ="tbl_ImportRH.DateRH"
    GroupLevel =0
    Expression ="Month([dateRH])"
    GroupLevel =0
    Expression ="Year([dateRH])"
    GroupLevel =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_ImportRH.DateRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="CompteDeCodeLigne"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="anneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="moisRH"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =687
    Bottom =840
    Left =-1
    Top =-1
    Right =671
    Bottom =527
    Left =0
    Top =0
    ColumnsShown =543
    Begin
        Left =48
        Top =12
        Right =337
        Bottom =319
        Top =0
        Name ="tbl_ImportRH"
        Name =""
    End
End