Export Table in Alphabetical Order

N

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
 
R

Ron2006

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

Ron
 
B

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top