creating a report that calculates

[edith]

Hello,

i'm creating a report in Ms Access that has to calculate the budget monthly.
How can i calculate and store the budget when it changes every month?

Appreciate the help.

[Ecniv]

A big company over here (UK) uses a forecast and an actual spenditure.
It stores the month and year and the forecasted amount, then has the actual amount to compare against.

To answer your question, you need to do the calculations before and then have the report pull them in.

Oh and store each month/year and the budget then.