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
|
|||
|
|||
Incorrect Sort Order in Form
I created a new Access database by importing data from Excel. Since then I
have added several dozen new records. In a basic report (everything defaulted except font and column widths) I want all records sorted by a Title column. In the report all records added since the table was created display at the top of the report in date added order, then all records imported originally from Excel display in Title order under the new records. What did I do, or how do I fix the, the sort order so all records display in alpha order by Title? |
#2
|
|||
|
|||
Incorrect Sort Order in Form
Hello,
If you are looking to sort the records on a form or report, base the form on a query. Do the Following: 1. Create a Query (use the wizard or create it in design view) with all the field that you need on your form. Select on the query "Title" and use the "Sort By" option, either ascending or descending. 2. On your form or report, use your Query as the Control Source. After doing this, your Form will display all the records in a sorted manner (by whatever field you specified in your query) -Scott Channell |
#3
|
|||
|
|||
Incorrect Sort Order in Form
On Fri, 13 Feb 2009 14:19:51 -0800, WAMozart wrote:
I created a new Access database by importing data from Excel. Since then I have added several dozen new records. In a basic report (everything defaulted except font and column widths) I want all records sorted by a Title column. In the report all records added since the table was created display at the top of the report in date added order, then all records imported originally from Excel display in Title order under the new records. What did I do, or how do I fix the, the sort order so all records display in alpha order by Title? The proper place to reliably sort a report is in the report's sorting and grouping dialog. Open the Report in design view. Click on View + Sorting and Grouping Enter the Title field in the left column Save the change. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|