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
|
|||
|
|||
Sory Order Problem in Report
Using Access 2007 on a Vista Ultimate computer. 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 alpha order under the new records. What did I do, or how do I fix the, the sort order so all records display sorted by Title? |
#2
|
|||
|
|||
Sory Order Problem in Report
On Fri, 13 Feb 2009 14:21:36 -0800, WAMozart
wrote: Using Access 2007 on a Vista Ultimate computer. 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 alpha order under the new records. What did I do, or how do I fix the, the sort order so all records display sorted by Title? Open the Report in design view; select View... Sorting and Grouping. Specify the sort order there. Save the report and it will henceforward sort the records as requested. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|