If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Incorrect Total on Main Report
In one of my reports The Main Report presents the accounts while the
sub-report consists the positive and negative transactions pertaining to such an account. On the main report I have three text boxes. Two of them representing the SUMs of the Positive and the Negative amounts separately, while the third presenting the result. However, unfortunately the third box instead of presenting the difference correctly, is presenting a type of running balance. With every new account the result from the last account is simply adjusted. In other words, it is only the first account that is presented correctly and the last one presenting zero balance? any reason? and way out? -- Thanx & Best Regards, Faraz! |
#2
|
|||
|
|||
Incorrect Total on Main Report
Check to make sure the Running Sum property is set to No.
-- Duane Hookom Microsoft Access MVP "Faraz Ahmed Qureshi" wrote: In one of my reports The Main Report presents the accounts while the sub-report consists the positive and negative transactions pertaining to such an account. On the main report I have three text boxes. Two of them representing the SUMs of the Positive and the Negative amounts separately, while the third presenting the result. However, unfortunately the third box instead of presenting the difference correctly, is presenting a type of running balance. With every new account the result from the last account is simply adjusted. In other words, it is only the first account that is presented correctly and the last one presenting zero balance? any reason? and way out? -- Thanx & Best Regards, Faraz! |
#3
|
|||
|
|||
Incorrect Total on Main Report
"Faraz Ahmed Qureshi" wrote in message ... In one of my reports The Main Report presents the accounts while the sub-report consists the positive and negative transactions pertaining to such an account. On the main report I have three text boxes. Two of them representing the SUMs of the Positive and the Negative amounts separately, while the third presenting the result. However, unfortunately the third box instead of presenting the difference correctly, is presenting a type of running balance. With every new account the result from the last account is simply adjusted. In other words, it is only the first account that is presented correctly and the last one presenting zero balance? any reason? and way out? -- Thanx & Best Regards, Faraz! |
Thread Tools | |
Display Modes | |
|
|