Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 6th, 2012  |  syntax: None  |  size: 0.58 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Sum a Calculated Field in Access Report
  2. Parent1     PARENT COMPLIANCE: 45% <- (40% + 50% / 2)
  3.       Child1
  4.            TOTAL WITHIN CHILD: 50
  5.            CONDITION 1       : 20%
  6.            CONDITION 2       : 40%
  7.            CONDITION 3       : 60% <- Implies 30 out of 50 compliant
  8.            CHILD COMPLIANCE  : 40% <- (20% + 40% + 60% / 3)
  9.       Child2
  10.            TOTAL WITHIN CHILD: 20
  11.            CONDITION 1       : 25%
  12.            CONDITION 2       : 100%
  13.            CONDITION 3       : 25% <- Implies 5 out of 20 compliant
  14.            CHILD COMPLIANCE  : 50% <- (25% + 100% + 50% / 3)
create a new version of this paste RAW Paste Data