Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Query - Column order changes. Argh.
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 | |||
copy cells down a column (in order) to across a row (same order?? | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
Microsoft Query - Entering Column Names with Blanks | Excel Discussion (Misc queries) | |||
Microsoft Query - Change the order of the fields | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) |