how do I create invoices and receipts for tenants

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

judesterr - 10 Oct 2005 07:10 GMT

i need to be able to show amount in $ of rent due and the period it covers,
and also if tenant pays a little bit more so they are in credit, how to
calculate or show that.

Reply to this Message

Arvin Meyer [MVP] - 10 Oct 2005 10:58 GMT

> i need to be able to show amount in $ of rent due and the period it covers,
> and also if tenant pays a little bit more so they are in credit, how to
> calculate or show that.

There are several ways to do what you want. One of them is to create several
tables:

tblRents
RentID
TenantID
BldgID
Rent
...

tblTenants
TenantID
...

tblRentTransactions
TransactionID
RentID
PeriodCovered
AmtPaid
DatePaid

A query joining tblRents and tblRentTransactions can have added columns
showing and differences between the Rent and the AmtPaid. A second query
based on the first, can show the balance, either due or in credit.

Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Reply to this Message