So I'm not sure that is the best title, but couldn't think of anything much better. Here's what I'm trying to accomplish.
I have a table that stores all of my units and their rent amount for the month:
RentAmounts (
UnitNum, -- IE (1A,2A,3A,4A)
RentMonth, -- IE(1,2,3,4)
RentYear, --...