Hi,
I have made a query to combine data from three DataTables.
In the Query Object, I want to change the column order of the combined data. I have done that in Design View (surely there to change the design??). I have pressed "Run" in Design view; also "Update Data".
But the Data Sheet view just doesn't seem to change the column order, according to how I have changed it in Design View.
Why? What's the solution? What's the point of Design View, if you can't design!!
I have made a query to combine data from three DataTables.
In the Query Object, I want to change the column order of the combined data. I have done that in Design View (surely there to change the design??). I have pressed "Run" in Design view; also "Update Data".
But the Data Sheet view just doesn't seem to change the column order, according to how I have changed it in Design View.
Why? What's the solution? What's the point of Design View, if you can't design!!