Sorting by alphabet after new input

[Cranky]

Hi

I'm sure this is probably very easy, but I can't seem to do it.

I've inherited a database of around 250 records. Since then I've added
around another 50 names, which have had autonumber allocate their
reference. However, when I print off all records in a report, the order
seems all over the place, not the alphabetical order it is set to. I've
gone into the table and sorted by surname, by autonumber, by various
other fields, but the print order doesnt seem to match any of these.

Is there a way of reallocating the autonumber so that every time I add
a new record, the first name alphabetically is (re)allocated number 1,
the next, 2, and so on?

Thanks in advance

Alan

 

[Allen Browne]

The sorting in the report is defined in the Sorting And Grouping dialog.

Open the report in design view.
In this dialog (on the View menu if you don't see it), choose the Surname
field on the first row. You can also choose the FirstName field on the 2nd
row if you want to sort by FirstName where people have the same Surname.

For other contexts, you can create a query and use the Sorting row to
determine the order of the records.

 

[Wayne-I-M]

If it's only the printed report that you want sorted and not the actual
query,form,table then you should sort the report itself.

Open the report in design view and click the sort button (it's on the top
menu) and sort the records as you want them to appear in your printed results.

 

[Cranky]

Hi Wayne,

Thanks for replying. I'd triedAllen's advice and it did what I needed.

S

 

[Cranky]

Allen

That worked prefectly.

Thanks a lot.

S

 

[Wayne-I-M]

No worries

Enjoy