...

View Full Version : working with date



designer_bhutan
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

thanks

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

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

HTH, Tom



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum