Re: putting the total row at the end of a cross tab query

anthonysjo wrote:
> Rick thanks for the help, it worked!!!
>
> Funny thing is that it looks exactly the same in the design view but
> I have a feeling that the underlying SQL changed.
>
> Thanks again for the help!!

No. As explained in a previous thread a couple days ago Access stores quite
a few properties about a table and/or query that you do not see in the GUI.
Column order, Column width, Hide/Show of Columns, Sorts and Filters applied
to the Data*** instead of in the QueryDef, etc.. What you did was change
one of these properties as it relates to the positions of the columns. If
you copied your SQL into a freshly created query the column order would not
be the same.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.