Thank you everyone for your responses.

I actually worked it out as follows.

In the report grouping I put in

=Switch(DatePart("ww",LoadDate) = 1,1)

and so forth, up to 52.

I know you're probably laughing, but, it worked, and fast too.

Thanks again.