Apartment rental database

[Donn]

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.

 

[Geof Wyght]

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.

 

[Stephen]

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.

 

[IAN K]

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