Run a report of what is missing.....?

[Pascoe via AccessMonster.com]

Hi there folks,

I have a problem that I have been mulling over for sometime, but finding the
solution is elusive - perhaps you may have an idea to help me on my way?

I have a database that tells me the name of every tenant and how much rent
they pay in a portfolio of property. I can very accurately say how much rent
was paid in any given time period.

However, what I would like to do is establish what is empty in any given time
period !!!!! i.e. run a report on what data is missing / not present.

The properties are either rented per room (Room A, Room B, Room C etc) or by
the entire property (EF...Entire Flat). I have a table that holds all the
addresses of each property, and holds within how many bedrooms the property
has, there is no "Room A, Room B etc column/field.

Currently my thought process is to run an occupancy report, and somehow work
backwards from that, but I JUST CANNOT work out the working backwards bit
right now!

Any thoughts will be eagerly read!

Thank you!
Russell.

 

[Barry A&P]

Russell

I am new at this But may have some help...
if you track payments made in their own table. you may be able to do a
query based on the Dmax payment date then set the criteria to something
like < date()-30 and that would give you payments that have not been made in
the last 30 days any way

Maybe just something else to look at..

you could also set up a query that would have todays date - first
occupancy date to get payment periods Multiplied by their rate and compare
that to the total payments data you already have to get the amount they are
behind..

Just a newbies thoughts
take what you want

Barry