how do I create invoices and receipts for tenants

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
judesterr said:
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.
Click to expand...

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top