openaccess/test/source/queries/r_SyntheseRH_inter.bas

dbMemo "SQL" ="SELECT r_DonneesImport.CodeAgent, tbl_Agents.Nom, Sum(r_DonneesImport.HeureSup1)"
    " AS SommeDeHeureSup1, Sum(r_DonneesImport.HeureSup2) AS SommeDeHeureSup2, Sum(r_"
    "DonneesImport.HeureSupDimanche) AS SommeDeHeureSupDimanche, Sum(r_DonneesImport."
    "Repas) AS SommeDeRepas, r_DonneesImport.MoisRH, r_DonneesImport.AnneeRH\015\012F"
    "ROM tbl_Agents INNER JOIN r_DonneesImport ON tbl_Agents.CodeAgent = r_DonneesImp"
    "ort.CodeAgent\015\012GROUP BY r_DonneesImport.CodeAgent, tbl_Agents.Nom, r_Donne"
    "esImport.MoisRH, r_DonneesImport.AnneeRH\015\012ORDER BY r_DonneesImport.CodeAge"
    "nt;\015\012"
dbMemo "Connect" =""
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbByte "RecordsetType" ="0"
dbBoolean "TotalsRow" ="0"
Begin
    Begin
        dbText "Name" ="r_DonneesImport.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeHeureSup1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeHeureSup2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeHeureSupDimanche"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeRepas"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Nom"
        dbLong "AggregateType" ="-1"
    End
End