Re: Calculate until End of Financial year

Look at the DateDiff function in the Help file. It will give you the number
of months between two dates.

--
PC Data***
Your Resource For Help With Access, Excel And Word Applications
Over 1125 users have come to me from the newsgroups requesting help
resource@xxxxxxxxxxxxxxx


<NoRegrets_jackhammer2485@xxxxxxxxx> wrote in message
news:YNudnaQL1PwjEJ7ZRVnyig@xxxxxxxxxxxxxxx
Does anybody have the faintest idea how i can achieve this????

How can i calculate the number of months between a given date =Now() and
the
31 March, and use this to make further calculations


for example

i have a table of work requests that have been submitted.called [tblWork]

fields that hold the relevent data are within this table:


[Date completed], with the format property set to Date/Time

[One off charge], with the format property set to Currency

[Monthly Charge], with the format property set to Currency

and [total charge] with the format property set to Currency

the one off charge and monthly charge will be entered i would the like the
calulation to work out the total charge.

I.e.

I submit a work request which is completed on 27 Feb 06.
the monthly charge for the work is $100

the one off charge is $20

so i need to:

a. calculate the number of months (either whole or part of) ie 2 (Feb and
Mar)
b. Multiply this number by the monthly cost ie $100*2 =$200
c. add to this the one off cost. $200+$20
d. display the answer in the [total charge field] total charge $220

Apologies for this layout i hope ive explained it well enough,


.