J
jor
Any Help Please. . .
I am new in access, and im doing some calculations from my query design. I
need to calculate two fields in a query. It is like cascading calculation
that the new field is the result and that result will be added to 2nd and to
3rd row and so on. The calculation is on hh:mm in 24 hr format. please see
example:
OnChk OffChk On/OffDifference Total Hour
8:59 13:45 4:46 1110:57 => This is carry over figure
8:50 12:57 4:07 1115:04
7:48 9:49 2:01 1117:05
1. I got the On/OffDifference by using "'IIF'' but the result from the 1st
and 2nd rows are negative.
2. In the Total Hour i want to add the result from the carry over figure
1110:57 plus the result of the on/offdiff from the 2nd row and the result to
3rd row and so on. .
3. I tried the answer of sharkbyte from stephanie's question dated 1/23/06
but i failed to do it.
Your help is very much appreciated. .
Thanks in advace.
jor
I am new in access, and im doing some calculations from my query design. I
need to calculate two fields in a query. It is like cascading calculation
that the new field is the result and that result will be added to 2nd and to
3rd row and so on. The calculation is on hh:mm in 24 hr format. please see
example:
OnChk OffChk On/OffDifference Total Hour
8:59 13:45 4:46 1110:57 => This is carry over figure
8:50 12:57 4:07 1115:04
7:48 9:49 2:01 1117:05
1. I got the On/OffDifference by using "'IIF'' but the result from the 1st
and 2nd rows are negative.
2. In the Total Hour i want to add the result from the carry over figure
1110:57 plus the result of the on/offdiff from the 2nd row and the result to
3rd row and so on. .
3. I tried the answer of sharkbyte from stephanie's question dated 1/23/06
but i failed to do it.
Your help is very much appreciated. .
Thanks in advace.
jor