Thank you Alan. Appreciate your contribution.:-)

Thanks to both answers. I am writing front end select only and not that experienced.

So the line below worked but I forgot to say that I need 2 values...

I did say I am a basic user but I also do all work on the db 🙂

The only way I thought I can do this is to run sqlcmd...

Many thanks for the quick reply and its content. I will get some sample data through hopefully by tomorrow.

Thanks for the input. Also many thanks for the interesting links ... good reading coming up.

Obviously I need to work on this as I don't think it is straight...

Thanks for your answer. I have not done pivoting before (not even in Excel!) so I will experiment and see what comes out.