design view does not match datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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.
 
Back
Top