Hi,

What I have is a rental company with several apartments to rent,

the database has the fileds (amongst others) apartment ID, client ID, rental start date, number of days rent.

what I want is a report that shows the days of the month, then for each apartment simply marks the dates in red when the apartment is occupied.

I imagine it looking something like this:

Month: AUG
APT ID: 1
|1|2|3|4|5|6|7|8|9 etc.

any help would be gratefull apreciated.