X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Booked And Available Rented Properties, Clashes For Hire Items, Access 2003    
post Apr 27 2012, 07:22 PM

Utterly Eccentric and Moderator
Posts: 4,119
Joined: 4-March 00
From: Bristol / Ipswich / Spain/Gloucester

This is an abstract from a very large holiday rentals property app. which I have been developing for the last 14 years, since Access 97. It demonstrates how the fairly complex SQL is constructed and has reports and calculations based on that. Rentals is a complex business, properties can have many daily rates - according to time of year and there is a system for calculating these daily rentals for any given period within the seasonal rates table. More seasons can be added at will.
This answers the perennial question of available, booked and clashed rental periods. The SQL can be adapted to any other hire items, staff holiday planning, anything where scheduling is the object. This is based on number of nights booked but will hold up for any period including periods of less than 24 hours if time fields were added. A formatted Xcel template is included so that bookings may be automatically exported as diagramatic coloured blocks to Excel.
Attached File(s)
Attached File  AvailabilityDemo.zip ( 367.92K )Number of downloads: 484
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    12th July 2020 - 02:23 PM