id really like to understand what the cross join does, but if it is too much time to describe i will go look it up 🙂

believe it or not i tried to work it out and got it working, i came here to post the result but you beat me to it.................but many thanks to...

ok that works but i want to add week as well (sorry guys) as soon as i add vs.week = 36 it doesn't work.

now i am getting confused 🙂

Maybe i need to explain better?

I need all the items from the items table but i would also like the query to look in the...

ok understood, so how do i change it to work?

A big thank you to everyone who has put some time in to help me, thank you very much.

Ok i have run the query and it seems to be ignoring...