How To Create An Index Report In Access

Have you ever wanted to create an Access index report for a list of names? This article describes how to create a report from a data table containing fields including Firstname and Surname, with the report sorted by surname and indexed under the appropriate letter of the alphabet. The steps to do this are firstly to create a query which lists all the table fields and the first letter of each surname. Then secondly to create a report based on the query, and then thirdly to organise the report sorting and grouping, with the data grouped under the appropriate letter of the alphabet.

The full article appears here:
http://www.microsofttraining.net/article-1618-how-create-index-report-in-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com