I'll tell you the same thing I always tell folks, Access is good for tracking
data information, Excel is better at tracking financial information.
It may be best to create a new Excel spreadsheet and then create tabs for
each unit. That way you can track the financial aspect of your complex. Then
create a database with all of the non-financial data about each unit, and
another table for each renter, you can tie the renters together with the
units and also link to the Excel spreadsheet for all of the financial
informtaion which will change on a daily/weekly/monthly basis.
