Thank you. I shall try this tomorrow. I will report back and let you know.

So basically I dont need to enter all the red.. I just enter... the below? It will be impossible to enter all the values in red.

SELECT * FROM (

SELECT...

Wow, thank you. Would I need to enter all the data from the table, ie. 1m rows? or can I just reference the table?

Thank you, I will look in to these.

Cheers

What an awesome idea for the user group. Thank you.