Apartment rental database

Trying to design a database to record tenants, Date paid, Receipt Number, 7
income catagories (Rents, Damage Deposits, Credit Checks, Late Fees, Credit
Bureau Pymts, Court Payments, Other Payments). I would like to total up each
month by catagorie as well as total receipts.

Tenant table could have tenantid (autonumber), first name
last name. Room table could have roomid (autonumber) or
room number, # rooms. Then make a tenant-room x-reference
table with tenantid, roomid, start and stop dates. Make a
lookup table of income catagories: incomecatid
(autonumber), description. Then make an x-ref table of
tenantid, roomid, date, incomecatid.
Does that help?
Geof Wyght.
-----Original Message-----
Trying to design a database to record tenants, Date
paid, Receipt Number, 7
income catagories (Rents, Damage Deposits, Credit
Checks, Late Fees, Credit
Bureau Pymts, Court Payments, Other Payments). I would
like to total up each
month by catagorie as well as total receipts.
.

It sounds to me like you could use a series of queries, with the month
function (maybe year too) that breaks your date down for you, then use a
totals query to group by month. You might want one query that groups by
tennant, giving you totals for that specific tennant, and you might want one
without the tennant, that would give you a total for the property. You may
also want to add a calculated field that will add the amounts for each
catagory, then group on month, and sum on your caluclated total field.

Another way is to export the raw data into Excel. After all it is a
spreadsheet.

"Geof Wyght" wrote:

Tenant table could have tenantid (autonumber), first name
last name. Room table could have roomid (autonumber) or
room number, # rooms. Then make a tenant-room x-reference
table with tenantid, roomid, start and stop dates. Make a
lookup table of income catagories: incomecatid
(autonumber), description. Then make an x-ref table of
tenantid, roomid, date, incomecatid.
Does that help?
Geof Wyght.
-----Original Message-----
Trying to design a database to record tenants, Date
paid, Receipt Number, 7
income catagories (Rents, Damage Deposits, Credit
Checks, Late Fees, Credit
Bureau Pymts, Court Payments, Other Payments). I would
like to total up each
month by catagorie as well as total receipts.
.

have you got a good spreadsheet for residential rental income yet?
--
IAN KEARNEY


"Donn" wrote:

Trying to design a database to record tenants, Date paid, Receipt Number, 7
income catagories (Rents, Damage Deposits, Credit Checks, Late Fees, Credit
Bureau Pymts, Court Payments, Other Payments). I would like to total up each
month by catagorie as well as total receipts.