Hello,
I was just wondering how it would be possible to obtain a field called
'week ending' which would give me a list of all the sunday's dates for the
coming year.

The following function will give the date for the SATURDAY following the
date supplied. You'll need to adapt it to obtain Sunday's date, wich
might be as easy as adding 1, but I'm not certain and don't have time to
play with it.

weekEndingDate = DateAdd("d", myDate, (7 - DatePart("w", myDate)))

Fred wrote:
> Hello,
> I was just wondering how it would be possible to obtain a field called
> 'week ending' which would give me a list of all the sunday's dates for the
> coming year.