Sorting the field display in Queries

  • Thread starter Thread starter Berni
  • Start date Start date
B

Berni

When linking tables in a query, access puts the index
fields on top of the list. I would like to see it sorted
the same way Crystal Reports allows me to sort it
ascending. Is there a way to do so??

Any help will be greatly appreciated.

Berni
 
Berni,
Access queries always sort columns from left to right.
So, you can select any column(s) and drag it to a new position on the QBE
grid. Then set it's/their sort to Ascending or Descending.

Be aware that any sort order in the query is irrelevant to the sort order in
a report based upon this query.
Sort the Report in the Report's Sorting and Grouping dialog:
In Report Design View, click
View + Sorting and Grouping.
 
Fred,

I guess I was not clear enough in my original description.

The problem is with the way a query displays the field
names within a table ready to be linked with another
table. By default Access places all the indexed columns up
on the very top in bold followed by the rest of the fields
in some sort order.

I like to see the fields listed in alphabetical order in
each of those tables so I can find the fields to link
easier.

Berni
 
Back
Top