I realize this may have a simple solution but I havent been able to find it anywhere. I have queries on a ACCESS database that the users is constantly dragging & dropping to new positions when viewing the query and putting it totally out of order. Of course then he complains its out of order! Is there an easy way to get the fields back to the original order? I dont want to drag and drop adinfinitium. I cannot find an option to do this. I have gone so far as delete and put the SQL code back in the query but it doesnt change what he messed up. The only thing that seems to work is actually deleting the query entirely and then creating it from scratch. Unfortunaly this is not a valid option as he is constantly doing this and wont stop.
Thank you in advance - I am on ACCESS 10.