If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. . |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
Apartment rental database
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
Archiving A Database | PC User | General Discussion | 2 | November 2nd, 2004 11:16 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |
DATABASE SQL staments | ediaz | Mailmerge | 2 | May 5th, 2004 07:20 AM |