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