hi in my program the users need to update his record every week. every week there will be a different food that will be given to him. i have a table where his info are saved, column week determine what week it is?(1 month = 4 weeks) i want to increment the value in week column to determine if its his 1st,2nd,3rd or 4rth week? if he updates his record on the 4rth week, column week will be 1 again.
example....
date___|week
august 1 | 1
august 8 | 2
august 16 | 3
august 24 | 4
august 31 | 1
sept 7 | 2
this is how i wanted to happen but dont know how... thanks...