Incorrect Sort Order in Form

[WAMozart]

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?

 

[channell]

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

 

[fredg]

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.