View Full Version : working with date

12-13-2007, 04:58 PM
hi, i am developing a small hotel reservation portal for which i have to display total cost of stay for the given dates.

eg: if my date of reservation is from 25/01/2008 to 05/02/2008 then i have to get the rates from 2 diff. records i need a clue to do this.

i have an access database that looking like this:

fromDate toDate Rate
01/01/2008 30/01/2008 100
01/02/2008 29/02/2008 200
01/03/2008 30/03/2008 300


Whatever Jr.
12-13-2007, 10:05 PM

That table design isn't gonna work. Consider using a calendar table.

HTH, Tom