Design & SQL Column Order not same as Datasheet

[David McCulloch]

Why would a Query's column order in Design view and SQL view not match the
column order seen in Datasheet view?

The SQL view's column order is consistent with that of the Design view.
Unfortunately, when I open the Query (or change the view to Datasheet), the
column order is consistent with that of the table.

Help!!!

 

[Duane Hookom]

Because someone might have drug the columns around while in datasheet view.
Just drag them back to the way you want (if it makes any difference).

 

[David McCulloch]

Could the columns have been moved around in Datasheet view without that
order appearing in the Design view?

FYI, I can flip between views (which I have done a dozen times since the
problem appeared) and immediately see the different column sequence.

FYI, column order makes a big difference, because Access is an intermediate
step to exporting the data. Access seems to export in the sequence defined
by Datasheet view.

Any help would be GREATLY appreciated.

Dave

 

[Van T. Dinh]

They are 2 different orders and they can be different!

If you want them to be the same, in the DatasheetView of
the Query, hightlight the Column(s) you want to move and
simply drag it/them left/righ to the column order you want.

HTH
Van T. Dinh
MVP (Access)

 

[Duane Hookom]

Again, while in datasheet view, just grab the column headings and drag them
to the order you want. If you don't want to do this, copy the sql to the
clip board and then paste it into a new query. The new one should "honor"
the column order.

 

[David McCulloch]

Van,

That insight helps me a lot -- thank you!!

Question... How could I have changed the column order of my Datasheets
without actually dragging the columns around? For example, I couldn't have
done that by simply opening the main table, could I? I created the queries
to help me map fields for the future when I will replace the contents of my
main table with new data (in preparation for exporting through my queries).

Dave.

 

[Van T. Dinh]

Sorry, I don't know.

Duane has covered more than I could ...

Van T. Dinh
MVP (Access)

 

[David McCulloch]

Thanks to both Duane and Van, I think that I found a work-around to my
problem. Although I still don't know how my Datasheet columns changed
position (I know that I didn't drag them anywhere), I found that if I export
from Design view, the exported columns will be in the same order that they
are in that view. When I was exporting from Datasheet view, it used THAT
view's column sequence.

Dave

 

[AnnWalk]

The same problem occurred in my table, when switching from Design view to Datasheet view, using Microsoft Access 2010. Thank you for the helpful solution. Moving the columns manually in Datasheet view worked.

 

[Wendasa]

This doesn't answer a question I have. I moved the columns around in Datasheet View, but they are the same as before when I look at Design View...?? How do I get them to match?? And, I've already tried dragging the field in Design View with no luck.

Also, I inserted a column in Datasheet View, but I can't change the Data Type in Design View. The drop-down menu appears, but when I select anything it doesn't take.

It's all mixed up...