Msg#: 4398519 posted 8:43 am on Dec 16, 2011 (gmt 0)
Hi, I have now finished and managed to add the dates and properties at the same time to my calendar table. So the table looks at this moment: 2012-12-01 property 1 2012-12-02 property 1 etc. until end of year 2012-12-01 property 2 2012-12-02 property 2 etc. until end of year (more properties to be added)
The next step is to update the table and add prices and description to make it easier to check the prices once done. So now I wonder if for exampel I have rows with dates 1 january until 30 March description low then I have 1 April until 30 June description mid. I know I can choose select low where property = property 1 however that will give me all rows from 1 january until 30 march. I wonder if it is posible to select the first and last date for description low, so the result would be property 1 low 2012-01-01 property 1 low 2012-03-30 That way I can check that the low season really ends when I want.
Msg#: 4398519 posted 9:00 am on Dec 16, 2011 (gmt 0)
Hmm, just had a second thought, maybe better to add another columned named start and enddate, so when I update the calendar choosing the dates with the form, first I insert the start and end date to that column, then I add price and description to the dated between choosen dates, so I would only have to select column start and enddates and I will get start and enddates with its description, price and property.....