Tricky question

[fatbloater]

I need help with something i think is tricky and would appreciate any input people can give. I am helping my uncle and i cant do what he would like.

I have a table that has a peak_time_start, peak_time_finish, peak_price off_peak_start, off_peak_finish and off_peak_price.

I also have a form with a button, this button, when pressed, puts time in the start field and then when pressed again puts time in the finish field.

The problem i have is working out the cost, firstly, what happens if we run through the times. I have messed around with an IF statement but this goes wrong when the time goes through off peak and into on peak. Also i would like to display the times as separate if they do run through.

Hope this is clear and not to tricky and someone can help!!!

 

[dching]

Your question seems very confused. Can you rephrase what you are trying to do.

Also, are the table fields correct, i.e. peak_price off_peak_start??