Alphabetized in an Access Report by first letter (Using Access 2007)

Delores_C
Delores_C used Ask the Experts™
on
How can I alphabetize records in a database based on the first letter of a name, and create the letter as the header
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
Check put his example: TelephonePhoneBook.zip
Top Expert 2011
Commented:
A simple solution is is to create a group header on the first charagter for the name.

Group on:
=Left(MyNameField],1)

Sort By: MyNameField

In the group header place a text box with the  control source of: =Left(MyNameField],1)
Top Expert 2011

Commented:
A simple solution is is to create a group header on the first character for the name.

Group on:
Left(MyNameField],1)

Sort By: MyNameField

In the group header place a text box with the  control source of: =Left(MyNameField],1)

Author

Commented:
works fine
Top Expert 2011

Commented:
Curious, Why a B?  What would have been better?

Boyd Trimmell aka HiTechCoach ( http://www.hitechcoach.com )
Microsoft MVP - Access

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial