how do I create invoices and receipts for tenants

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.
 
A

Arvin Meyer [MVP]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Adding Record in form - Related Data from related tbl doesn't show 5
user form 2
Create Records 1
IF THEN statement??? 3
Property Management Database Design 5
How do I populate a field in a form based on a value in a previou. 1
Looking for Methods on posting charges 2

Top