Forum

Hi Catalin, I have split the query and will add the try otherwise error catch. I just dont see how the Orders_Page2 query errors out when I thou...

Its OK I puzzled it out simply promoted headers before splitting into depot and PO then unpivot and split

Hi Guys, Thanks for all the replies so far but one key thing is missing the date in the first row isn't irrelevant. If you look at the result cs...

Awesome Mynda thank you just need to convert to use Folder.Files and a work around for some of the header names

Doh!!! I didnt even realise I had made it a table Thanks guys

Hi Phil, I thought there might be a watch window or something I could set to trace dependants etc. Its just formatted to "mmm" @velouria I j...

Doh

Hi Mynda, very strange as soon as I change anything in the query, it uploads the headers as dates and throws it all out of sync I've attached bo...