Quirk: Access not showing my columns in correct order

[oliviar]

Hi Guys,
I have reviewed both the design view and the SQL, and my 4th and 5th columns in these views (they are simple calculation columns) are showing up after my 15th column.
I have dragged the columns around, I've redone the SQL... I've pleaded ... for some reason Access WANTS these columns to show up after the 15th column.

BTW The 15th column is in the correct place, and it is also a calculation columns, but its not the end of the line. It is just one of 100 columns.

 

[boblarson]

First off 100 columns? Where are all of these columns coming from? Are they from multiple tables? If so, have you used the asterisk (*) at all when putting them into the query grid? That would explain why things are not letting you put them in certain spots.

 

[oliviar]

Asterisk?
They are coming from a few different queries. I'm mixing and matching them up.

 

[boblarson]

Asterisk?
They are coming from a few different queries. I'm mixing and matching them up.

Asterisk in like

Select * FROM QueryNameHere

or

SELECT QueryNameHere.* FROM QueryNameHere


What is the SQL of your query?

(post it in code tags so it is readible as I'm sure with 100 fields it is very, very long).