Help with date handling

[grinder332518]

My table has a {start of year} date in the format “dd/mm/yyyy”.
I need to pick this up as 'week1',
and then add 7 days, for a whole year, so that I can display :-
'week2', ({start of year} + 7 days)
'week3', ({start of year} + 14 days)
etc, etc, right up to 'week52', or 'week53' in a leap year.
Is there an easy way do this in FORMS, presumably with a date function ?
I don't know VB very well.
Many thanks in advance.

 

[Galaxiom]

Check out the DatePart function:
http://office.microsoft.com/en-au/access/HA012288121033.aspx

You can dynamically calculate the week from any date so it should not be necessary to store this information in a table.