Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query refresh changes column order - Help! (Pretty please?)
Hi!
I retrieve data from MS Access via MS Query and usually have no problem. However I have one query that is giving me fits. It is a crosstab query that uses the date as the column header sorted in descending order. It runs perfectly in Access. When I refresh my data in Excel the most current column is brought over as the furthest right hand column, when it should be the leftmost column in the table. So I have to move the column over by hand. Does anyone have any suggestions for fixing this? I'm sure it's simple and the problem is me........ I work in design view, not SQL, so if there's a design view fix I would be greatly appreciative. Thanks in advance for any help! Mrs. Rum |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Query - Column order changes. Argh. | Excel Programming | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |