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!

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!

"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!

;,;;v;,v

"Faraz Ahmed Qureshi" a écrit
dans le message de groupe de discussion :
...
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!