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
|
|||
|
|||
Export Table in Alphabetical Order
I am able to sort my records into alphabetical order of surnames on the
screen. However when I print a report it always comes out in the order the records were typed in (i.e. in ID order). Is there a way round this. If not is it possible to export my database (which is sorted in alphabetical order) so that the new one will have the ID column renumbered in alphabetical order? Many thanks for any advice. Noel |
#2
|
|||
|
|||
Export Table in Alphabetical Order
Change the recordsource of the report to a query of the table and sort
by the Surname. Ron |
#3
|
|||
|
|||
Export Table in Alphabetical Order
Noel
Reports have their own grouping/sorting properties. Open the report in design view and click on the Grouping/Sorting icon. Select the field your want to sort on. -- Bill Mosca, MS Access MVP http://www.thatlldoit.com http://mvp.support.microsoft.com/profile/Bill.Mosca http://tech.groups.yahoo.com/group/M..._Professionals "Noel S Pamfree" wrote in message ... I am able to sort my records into alphabetical order of surnames on the screen. However when I print a report it always comes out in the order the records were typed in (i.e. in ID order). Is there a way round this. If not is it possible to export my database (which is sorted in alphabetical order) so that the new one will have the ID column renumbered in alphabetical order? Many thanks for any advice. Noel |
#4
|
|||
|
|||
Export Table in Alphabetical Order
On Tue, 6 Jan 2009 14:04:32 -0000, "Noel S Pamfree"
wrote: I am able to sort my records into alphabetical order of surnames on the screen. However when I print a report it always comes out in the order the records were typed in (i.e. in ID order). Is there a way round this. I have to disagree with Ron and Bill here! You can use a Form based on a sorted query, but Reports ignore the order of records in the query (or for that matter in the table). What you need to do instead is open the report in design view; right mouseclick the little square at the upper left intersection of the rulers and select "Sorting and Grouping". This lets you specify the sort order of the records displayed on the report. If not is it possible to export my database (which is sorted in alphabetical order) so that the new one will have the ID column renumbered in alphabetical order? Well, you could, but it would be pointless and unnecessary - and a major pain whenever you needed to add another entry. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|