Auto numbering alphabetically

[D. M.]

Hello,

I have a DVD database with close to 1,000 titles. I am trying to create a
report where the DVD's are sorted by Movie Type, then alphabetically, then
numbered. So when I'm looking for a specific title, all I have to do is look
at the alphabetic list and easily find the title by number. I based my
database on the Microsoft DVD
Collection template.

Can anyone help?

Thanks,

 

[D. M.]

I think I need to clarify. I would like to see a list of DVD's by title,
then numbered alphabetically... as follows:

Action
A
1
2

B
1
2

 

[fredg]

Hello,

I have a DVD database with close to 1,000 titles. I am trying to create a
report where the DVD's are sorted by Movie Type, then alphabetically, then
numbered. So when I'm looking for a specific title, all I have to do is look
at the alphabetic list and easily find the title by number. I based my
database on the Microsoft DVD
Collection template.

Can anyone help?

Thanks,

In creating your report, use the report's Sorting and Grouping dialog
to set up the groups and the sort order. View + Sorting and Grouping