G
Guest
Query Example
Please can anyone tell me the correct expression to get Pay Field to
calculate running sum for me as below?
SecID Paid Rate TotalHours Total Pay
1 Yes £6.50 8.5 £55.25 £110.50
2 No £6.50 8.5 £55.25 £110.50
4 Yes £6.50 7 £45.50 £91.00
At the above Query Table I want formula to calculate and sum only the total
value with Yes in Paid Field
The above illustrate my problems
As Above the correct value suppose to be $201.50
I use the below expression on the query grid for Paid Field
Pay: [SeqQuery].[Total]+[Total]
Please reply to (e-mail address removed)
Many Thanks In advance
Please can anyone tell me the correct expression to get Pay Field to
calculate running sum for me as below?
SecID Paid Rate TotalHours Total Pay
1 Yes £6.50 8.5 £55.25 £110.50
2 No £6.50 8.5 £55.25 £110.50
4 Yes £6.50 7 £45.50 £91.00
At the above Query Table I want formula to calculate and sum only the total
value with Yes in Paid Field
The above illustrate my problems
As Above the correct value suppose to be $201.50
I use the below expression on the query grid for Paid Field
Pay: [SeqQuery].[Total]+[Total]
Please reply to (e-mail address removed)
Many Thanks In advance