report

[Guest]

i have a table with 4 coluns (date,descripton,debit,credit), in the the
report i have de same coluns plus another that is the balance
([debit]-[credit]). the problem is when i ask for a report limited for
example for 1 month the balance is never correct because access is only doing
the sum in that month. how can i resove this...

 

[DL]

If I understand you correctly you are producing a report based on a date
range;
The resulting report balances will only ever be applicable to that date
range.
What exactly are you trying to achive with the report? specifically the
balance.

 

[Guest]

i'm trying to do a bank statement, and when i ask only the statement of 1
month i want that the balance to have the correct balance (including the past
movements, previous balance). thanks, lightning

"DL" escreveu:

If I understand you correctly you are producing a report based on a date
range;
The resulting report balances will only ever be applicable to that date
range.
What exactly are you trying to achive with the report? specifically the
balance.

i have a table with 4 coluns (date,descripton,debit,credit), in the the
report i have de same coluns plus another that is the balance
([debit]-[credit]). the problem is when i ask for a report limited for
example for 1 month the balance is never correct because access is only doing
the sum in that month. how can i resove this...