Microsoft Query - Column order changes. Argh.

T

therums

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary 0
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
MS Query 7
query to show where no data in a stated column 0
bug - named ranges point to wrong column after being moved inside anMS Query Table 0
External Data from SQL Server 1
don't want column width change after refresh 2
Query Update from Access: Re Ordering Columns 0

Top