Need to develop a statistical report!

[aldipalo]

Please see above layout to get an idea of what I'm trying to accomplish.

I'm on the final piece of my first paid for gig and I'm completely stumped on how to develop a statistical report. This is for a Condominium Resort that has a minimum 2 week rental policy.

I need to have a report or group of reports that will:

1. Tell me the number of units that rent vs the total number of units.

2. The % of Units that rent vs total units.

3. The number of times a unit is rented during any date range.

4. % of rentals to total rentals by unit

5. Sort by units with most rentals

6. Sort by units rented by period (Season)

7. Show % of units rented by period to total units rented.

I have the following tables:

Units

:UnitID

::fk_OwnersID

::fk_RentersID

Owners

::OwnersID

::fk_UnitID

::fk_RentersID

Renters

::RentersID

::fk_UnitID

::fk_OwnersID

::r_StartDate

::r_EndDate

::c_Rental_Length

::c_Rented

The report would come from the Renters Layout Table

Renters_Layout -> Owners_Layout

Renters_Layout -> Units_Layout

I've tried setting up Summary fields to no avail.

I'm hopeful that if someone can help me figure out how to do 1 or 2 of these the rest will fall into place.

Of course any reading material or demo files that may be appropriate would be a great help as well.

Thanks for any help you can give me.

Al

Edited August 15, 2008 by Guest
Added jpg

[aldipalo]

If more or less data is needed please let me know and I'll be happy to supply it.