FAO Rick Sprague want to mae a calender that shows rental availability

[AKAC00L]

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|9| etc.

any help would be gratefull apreciated.

 

[RickSpr]

Sorry, AKAC00L, but reports are not my strong suit, especially when you want complicated tricks like this. I imagine part of your solution would be to sort and group by Apt ID, using code to collect data from the records in the detail and then printing this result when formatting the group footer. I haven't written any code like that, though, so I'm not sure it's possible.

I wouldn't know any way you could change colors, unless you put each number is in a separate text box control. If you do that, you can just change the Fore Color property as needed. Rick Sprague

 

[AKAC00L]

Thanks anyway Rick,

Am reposting this as I think no one else looked at it because it had fao rick at the start.