G
Guest
Hi there, I really hope you can help me!
I have a database that has a bunch of names and dates, names of tenants,
dates that they moved in, and moved out, and then some other stuff.
I have produced a report that only has the names of tenants that were with
us during a particular two dates (financial year). I now want to get a little
more clever and calculate the rent they paid between their two dates. Where I
am struggling is that I want to do something along the lines of;
IF (Date Moved in) < 5th April 2006 THEN (Date Moved Out - 5th April 2006) *
Rent
I have to make an analysis of whether the tenant moved in before the
beginning of the tax year, because I only want the rent payments DURING that
tax year, so similarly I need to do something similar for the date they moved
out because that maybe in the following tax year, so I only need to calculate
their rent to the end of the 06/07 year.
The only way I can (possibly ignorantly) spot to do this is with an IF THEN
statement, but I cannot find that functionality in Access, could someone
please give me a suggestion or two, I would be most grateful - will make my
life a lot easier!
Thanks.
Russell.
I have a database that has a bunch of names and dates, names of tenants,
dates that they moved in, and moved out, and then some other stuff.
I have produced a report that only has the names of tenants that were with
us during a particular two dates (financial year). I now want to get a little
more clever and calculate the rent they paid between their two dates. Where I
am struggling is that I want to do something along the lines of;
IF (Date Moved in) < 5th April 2006 THEN (Date Moved Out - 5th April 2006) *
Rent
I have to make an analysis of whether the tenant moved in before the
beginning of the tax year, because I only want the rent payments DURING that
tax year, so similarly I need to do something similar for the date they moved
out because that maybe in the following tax year, so I only need to calculate
their rent to the end of the 06/07 year.
The only way I can (possibly ignorantly) spot to do this is with an IF THEN
statement, but I cannot find that functionality in Access, could someone
please give me a suggestion or two, I would be most grateful - will make my
life a lot easier!
Thanks.
Russell.