I am trying to update the main form with each record in the subform.
I have two tables Invoice and Payment table.
The main form has the payment details which I need to update for each invoice selectedon the subform.
EG
Invoice Table (SubForm)
Ref no , Inv No , Amt
1 , 101 , 10.00
2 , 102 , 20.00 etc

Payment Table Feilds...

hi,
I had code written for me to create week no and start date increament every 7 days for each week but i would now like to create daily dates with week numbers and the day.
I have managed to create the daily dates but I cant seem to create the week no in intervals of 7 days of the week and the Day.
ie the results I need are
Wk No Date Day Year
1 01/01/10 fri 2010
...