Report Creation: Summing overt textboxes

Sprawl

Database Co-Ordinator
Local time
Today, 01:56
Joined
Feb 8, 2007
Messages
32
The report I'm creating has some duplicate values that are interfering with the data output. I need to somehow fix that! it would be best if i could do a sum of values in textboxes rather than the query. Here''s the query i have.

TEMPID ----------- DATE -------- TYPE ------- hRS --------- CPP ------ EI
121614000 --------12/31/06 ----- 100 -------- 44.00 -------- 1.2 ------ 3.21
121614000 --------12/31/06 ----- 200 -------- 4.00 --------- 1.2 ------ 3.21
121614000 --------12/31/06 ----- 300 -------- 48.00 -------- 1.2 ------ 3.21
121614000 --------12/17/06 ----- 100 -------- 44.00 -------- 1.8 ------ 3.0
121614000 --------12/17/06 ----- 200 -------- 4.00 --------- 1.8 ------ 3.0
121614000 --------12/17/06 ----- 300 -------- 48.00 -------- 1.8 ------ 3.0

Now the report needs to take those CPP and EI columns and do some math,

Basically the Total of the CPP on the report should end up as
CPP ----- EI
3.0 -----6.21
 

Users who are viewing this thread

Back
Top Bottom