r_FraisKm_SourceEtat.bas 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. Operation =1
  2. Option =0
  3. Where ="(((r_FraisKm3.CodeAgent)=[États]![Et_EtFraisDep]![CodeAgent]) AND ((r_FraisKm3.A"
  4. "nneeRH)=[États]![Et_EtFraisDep]![AnneeRH]) AND ((r_FraisKm3.MoisRH)=[États]![Et_"
  5. "EtFraisDep]![MoisRH]))"
  6. Begin InputTables
  7. Name ="r_FraisKm3"
  8. End
  9. Begin OutputColumns
  10. Expression ="r_FraisKm3.CodeAgent"
  11. Expression ="r_FraisKm3.AnneeRH"
  12. Expression ="r_FraisKm3.MoisRH"
  13. Expression ="r_FraisKm3.TypeVehicule"
  14. Expression ="r_FraisKm3.BorneInf"
  15. Expression ="r_FraisKm3.BorneSup"
  16. Expression ="r_FraisKm3.Valeur"
  17. Expression ="r_FraisKm3.DistanceMoisRepartie"
  18. Expression ="r_FraisKm3.Montant"
  19. End
  20. dbBoolean "ReturnsRecords" ="-1"
  21. dbInteger "ODBCTimeout" ="60"
  22. dbByte "RecordsetType" ="0"
  23. dbBoolean "OrderByOn" ="0"
  24. dbByte "Orientation" ="0"
  25. dbByte "DefaultView" ="2"
  26. dbBoolean "FilterOnLoad" ="0"
  27. dbBoolean "OrderByOnLoad" ="-1"
  28. dbBoolean "TotalsRow" ="0"
  29. Begin
  30. Begin
  31. dbText "Name" ="r_FraisKm3.Montant"
  32. dbLong "AggregateType" ="-1"
  33. End
  34. Begin
  35. dbText "Name" ="r_FraisKm3.CodeAgent"
  36. dbLong "AggregateType" ="-1"
  37. End
  38. Begin
  39. dbText "Name" ="r_FraisKm3.AnneeRH"
  40. dbLong "AggregateType" ="-1"
  41. End
  42. Begin
  43. dbText "Name" ="r_FraisKm3.MoisRH"
  44. dbLong "AggregateType" ="-1"
  45. End
  46. Begin
  47. dbText "Name" ="r_FraisKm3.TypeVehicule"
  48. dbLong "AggregateType" ="-1"
  49. End
  50. Begin
  51. dbText "Name" ="r_FraisKm3.BorneInf"
  52. dbLong "AggregateType" ="-1"
  53. End
  54. Begin
  55. dbText "Name" ="r_FraisKm3.BorneSup"
  56. dbLong "AggregateType" ="-1"
  57. End
  58. Begin
  59. dbText "Name" ="r_FraisKm3.Valeur"
  60. dbLong "AggregateType" ="-1"
  61. End
  62. Begin
  63. dbText "Name" ="r_FraisKm3.DistanceMoisRepartie"
  64. dbLong "AggregateType" ="-1"
  65. End
  66. End
  67. Begin
  68. State =0
  69. Left =0
  70. Top =0
  71. Right =1039
  72. Bottom =840
  73. Left =-1
  74. Top =-1
  75. Right =1023
  76. Bottom =215
  77. Left =0
  78. Top =0
  79. ColumnsShown =539
  80. Begin
  81. Left =48
  82. Top =12
  83. Right =346
  84. Bottom =301
  85. Top =0
  86. Name ="r_FraisKm3"
  87. Name =""
  88. End
  89. End