design view does not match datasheet view

[Guest]

This is driving me crazy and I cannot figure it out. In design view of the
query I dragged the column headings in the order I wanted them to appear.
When I go into datasheet view the columns are not even close to being in the
same order. Is there a way to control this?
Thanks

 

[Guest]

Run the query (not design, when it display the values), change the column
order by draging the column to the right location, close the query, you'll be
prompt with a message if you want to save the new layout, press yes, and that
should change the order

 

[Jeff Boyce]

Patricia

Are you saying that you've created a query that displays columns/column
headings the way you want to see the data, but that the underlying table
hasn't changed?

If you want the table to look different, you need to alter the table
definition.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

What probably happened is that you were in datasheet view and repositioned
one or more columns and then saved the change. Access then remembers this
as the way you specified the order of the columns and use that when you
switch to display view. Once you've done this it is a pain to get the
columns in the same order as the query.

Easiest way to fix this is to create a new query based on the old query.

Open your current query in design view
Select view: SQL from the menu
Copy the SQL text
Open a new query
Cancel the dialog to select table
Switch to SQL view
Paste the SQL text.

That should do it.