Unfortunately i cant trim down the columns the data from each table needs to bre represented in the column.

I think the best way to solve this would be to create...

I understand the issue with dates and times, this is how the tables were when i inherited them. I will amend them appropriately.

Essentially all i want to be able to...

Just read through your post, if you need me to rewrite the scripts please let me know

That seems exactly whats required to get them into one data set

I have created some scripts that will create and input some data into them see attached...I will read your...

Unfortunately i dont know if an order by will work. They are completely seperate tables not rows within one table.

I will do my best to get together some scripts for...

Check the "location" settings of the very top object in the properties toolbar thingy usually on the left

Sometimes it can be set some really silly infinitely small number like 0.00000000302mm

Apologies...