Thank you , this did solve it.

Appreciate all responses. Cheers

GilaMonster (7/2/2015)

Which doesn't help me to test queries that I write 😉

Something like

SELECT <stuff>

FROM...

Wow some seriously fast responses here. Thanks

I will try what you have posted and if I get nowhere will post some sample data up. Thanks a lot.

As I said a NOOOOOB

My table layout is

Not sure how I would go about without using a JOIN ????

Thank you for your help.