Column Order in Queries
Is it really necessary to re-arrange the column order when I save a query? It tells me MS Access is reducing the QBE grid entries into SQL, optimizing that syntax and when asked for it later the presentation looks scrambled. While this may be needed internally, how much harder can it be to ask the internals to remember the column order?
Oh, related thought. Why can't saved queries remember the column widths when saved?