I would make one function that returns the Daily Rate for any day in the year. Then another function that returns the Weekly Rate of any day in the year. Then the function that calculates how much to charge the customer could simply take the check-in date and then start calling the Daily Rate function for every day he stays and add it up. When he has stayed one week I would delete the sum and instead take the weekly rate etc.. jhaga CodeProject House, Paul Watson wrote: ...and the roar of John Simmons own personal Nascar in the garage. Meg flitting about taking photos.Chris having an heated arguement with Colin Davies and .S.Rod. over egian values. Nish manically typing *censur*. Duncan racing around after his pet *c.* Michael Martin and Bryce loudly yelling *c.* C.G. having a fit as Roger Wright loads up *c.* . Anna waving her *c.* and Deb scoffing chocolates in the corner. ...Good heavens!

A couple of things to check. It appears that you are trying to assign a int, float or char datatype to the "Checked" value of the checkbox. This should be a boolean datatype. In order to properly do this, you either need to add a helper function or add a new column to the query for HasRoom. If you use a helper function, you will want to pass the roomnumber value to it and if it is not null, return true. Function HasRoom(roomnumber as int) If roomnumber = '' then return false else return True End Function Then you would call this from the datagrid. Checked=<%# HasRoom(Databinder.Eval(container.dataitem, "roomnumber)) %> Hope this helps. Jeremy Oldham