Hi,
I wrote fao rick as he seems to know about this stuff fairly well and one of his old posts helped with the other prob I had.
Anyway, 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 etc.
any help would be gratefull apreciated.
I wrote fao rick as he seems to know about this stuff fairly well and one of his old posts helped with the other prob I had.
Anyway, 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 etc.
any help would be gratefull apreciated.