running sum in a report in ms ACCESS 2003 with criteria

[perryb]

Can somebody help me with the following problem:

The loan of a person is in
jan $100
febr $200
march $400
When I generate a report, with a unbound textbox for calculating the running sum, everything is going good so far (Running sum jan $ 100 , febr $ 300 and march $ 700
But when I have a criteria in the query and generate a report for i.e. only febr, the running sum is not $ 300(jan + febr), but only $ 200. Why

thanks

[zaidlig]

Can somebody help me with the following problem:

The loan of a person is in
jan $100
febr $200
march $400
When I generate a report, with a unbound textbox for calculating the running sum, everything is going good so far (Running sum jan $ 100 , febr $ 300 and march $ 700
But when I have a criteria in the query and generate a report for i.e. only febr, the running sum is not $ 300(jan + febr), but only $ 200. Why

thanks

Without the SQL is hard to see whats wrong. However it appears your criteria is set to = Feb where it should be < Mar.

[perryb]

Hi my friend,

I have only one table and one selectquery and on my report I have an unbound textbox for calculate the running sum.

I hope it is a little more clear for you.


thanks