I have a select query which has lets say the following columns A, B, C, D in design. I run the query and the datasheets shows the columns in the correct order A, B, C, D. There is a sort on B and D
I add a 5th column in design on the right of D, so we now have A, B, C, D, E
I run the query and the datasheet now shows E, A, B, C, D
What is causing this?
thanks