track rent
anonymous_at_discussions.microsoft.com
Date: 09/24/04
- Next message: Allen Browne: "Re: Filtering by a calculated field/control"
- Previous message: Chris E.: "Re: Simple count query not so simple..."
- In reply to: Josh Henry: "track rent"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 09:15:55 -0700
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.
>-----Original Message-----
>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
>.
>
- Next message: Allen Browne: "Re: Filtering by a calculated field/control"
- Previous message: Chris E.: "Re: Simple count query not so simple..."
- In reply to: Josh Henry: "track rent"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
