If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Automatically Moving Criteria Columns to End of Query (DesignView)
I have a query being run where the position of the criteria (in Design
View) is important to pull the data correctly. However, I have to move this column to the correct position each time I run the query, as Access automatically moves not shown columns to the end of the query in design view. Is there a way to stop Access from automatically reordering the columns? Thanks. |
#2
|
|||
|
|||
Access Automatically Moving Criteria Columns to End of Query (Design View)
Mike,
Yes, there is... do not use the query for data entry, use a form which you can set up to look just like query datasheet view. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mike" wrote in message ... I have a query being run where the position of the criteria (in Design View) is important to pull the data correctly. However, I have to move this column to the correct position each time I run the query, as Access automatically moves not shown columns to the end of the query in design view. Is there a way to stop Access from automatically reordering the columns? Thanks. |
#3
|
|||
|
|||
Access Automatically Moving Criteria Columns to End of Query (Desi
Why does it matter where the not shown columns are?
If you are using it for sorting then just create aliases for all your sort columns and make them not shown. -- Build a little, test a little. "Mike" wrote: I have a query being run where the position of the criteria (in Design View) is important to pull the data correctly. However, I have to move this column to the correct position each time I run the query, as Access automatically moves not shown columns to the end of the query in design view. Is there a way to stop Access from automatically reordering the columns? Thanks. |
#4
|
|||
|
|||
Access Automatically Moving Criteria Columns to End of Query(Design View)
The position of criteria in QUERY design view will not change what data is
displayed. However, if you are attempting to SORT by those columns (that is not criteria) then you need to add the Additional columns you are sorting by again and make the second instance NOT shown. Then put all the sorting columns in the desired order. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Mike wrote: I have a query being run where the position of the criteria (in Design View) is important to pull the data correctly. However, I have to move this column to the correct position each time I run the query, as Access automatically moves not shown columns to the end of the query in design view. Is there a way to stop Access from automatically reordering the columns? Thanks. |
Thread Tools | |
Display Modes | |
|
|