Hi Hugo,

i will reply to you once ive done it.

Holy moly Hugo - you're too good!!!!

I will have to read it slowly and understand the logic and test your code. I am on a charity run tomorrow but...

it does make sense.

ignore everything else ive said, just look at my previous post, create the table orders and insert those values into orders.

and i would like the output as...

hope this is clear.

also many theres a way to have a loop counter rather than me duplicating the same code 52 times with a new column name???

your help is much appreciated.

you can run the following with

thanks for that dwain.c.

that helped a lot.

manage to work on it and also add a few things to your solution.

much appreciated.