sum function problem
I am doing a report in which the query that is being used utilizes two tables. In the report it totals up three columns. One of the columns it sums up fine but the other two does not. Here is the design view of the report:
amount =sum(total) =amount-txttotal
Total: =Sum(amount) =sum(total) =Sum(amount-txttotal)
Incorrect Correct Incorrect
I know for a fact the reason why both of these formulas do not work is because of the middle formula. One table entitled AllTasks table shows all the tasks being paid. For example, Task 1 is 15,000 Task 2 is 5,000 etc. What is happening is the amount field is duplicating itself by the amount of tasks from the total field. Both the Amount field and Total field are from seperate tables. Is there a way to correct this please?? Thanks :D
slypunk
__________________
slypunk
|
