Export Table in Alphabetical Order

[Noel S Pamfree]

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

 

[Ron2006]

Change the recordsource of the report to a query of the table and sort
by the Surname.

Ron

 

[Bill Mosca]

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.

 

[John W. Vinson]

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.