track rent

[Josh Henry]

I need to come up with a table that tells me how much rent
is due YTD because i'm gonna combine it w/ a query i have
that tells how much rent each tenant has paid YTD. Some
tenants have not been in the apartments all yaer long &
others have, so some will need to be pay for less months
than others. I already have one table that shows each
tenant and the cost of their apartment. thanks

 

[Guest]

Josh,

I'd create a query that defines the number of months, and
maybe even days, your tenant has been renting from you.
What you'll need to use is a field that indicates the date
the tennant started renting from you(I named it "date
joined") and from there you can calculate the number of
months the tennant has been with you. You can even go down
to the number of days if you'd like.

Date () indicates current date.

Num_months: Month(Date()-[date joined])

Save this query, then use the values defined in this query
to multiply by the monthly rental rate for a total due YTD.

Hope this helps.