>>Naomi,
>>
>>And are you sure in your data you have at least one entry for every day?
>
>Good catch! That's what I figured myself too. I need an extra cursor with all weeks and first dates to join with my select, I guess. Or how do you think I should create my select without this extra cursor? Assuming I don't want to create this extra file and I can skip weeks with no dates?
>
>Thanks.

In other words, given a year and a week, how can I construct first day of the week?