Totals devided into monthly amounts

[Guest]

I have a number that gets entered into my database as a record that is the
total spent to date each month. I would like to be able to calculate from
that total and the subsequent total the amount spent for the month. Subtract
last months total from this months total. I can not for the life of me
figure out how to do this easily. And yes I know I could get a calculator
out and figure it out before I enter it, but is there some way in access to
calculate this number. Thank for your help in advance.

 

[Guest]

Create a calculated field in your query:
MonthTotal: [ThisMonthTotal] - [LastMonthTotal]

 

[Guest]

Each record contains the total amount. How do I get the past total in there
to calculate without typing it in?

Create a calculated field in your query:
MonthTotal: [ThisMonthTotal] - [LastMonthTotal]

I have a number that gets entered into my database as a record that is the
total spent to date each month. I would like to be able to calculate from
that total and the subsequent total the amount spent for the month. Subtract
last months total from this months total. I can not for the life of me
figure out how to do this easily. And yes I know I could get a calculator
out and figure it out before I enter it, but is there some way in access to
calculate this number. Thank for your help in advance.

 

[Guest]

Maybe I misunderstood. Are you sayin that record 1 has the total for
January, record 2 has the total for february, record 3 has the total for
March, etc. and you want to subract January total from February total,
February total from March total, etc?

Each record contains the total amount. How do I get the past total in there
to calculate without typing it in?

Create a calculated field in your query:
MonthTotal: [ThisMonthTotal] - [LastMonthTotal]

I have a number that gets entered into my database as a record that is the
total spent to date each month. I would like to be able to calculate from
that total and the subsequent total the amount spent for the month. Subtract
last months total from this months total. I can not for the life of me
figure out how to do this easily. And yes I know I could get a calculator
out and figure it out before I enter it, but is there some way in access to
calculate this number. Thank for your help in advance.

 

[Guest]

Yes. The totals come out of a system that gets entered but I would like to
show how much it changed from the previous month.

Maybe I misunderstood. Are you sayin that record 1 has the total for
January, record 2 has the total for february, record 3 has the total for
March, etc. and you want to subract January total from February total,
February total from March total, etc?

Each record contains the total amount. How do I get the past total in there
to calculate without typing it in?

Create a calculated field in your query:
MonthTotal: [ThisMonthTotal] - [LastMonthTotal]

:

I have a number that gets entered into my database as a record that is the
total spent to date each month. I would like to be able to calculate from
that total and the subsequent total the amount spent for the month. Subtract
last months total from this months total. I can not for the life of me
figure out how to do this easily. And yes I know I could get a calculator
out and figure it out before I enter it, but is there some way in access to
calculate this number. Thank for your help in advance.