<div>
Check put his example: <a href="http://lebans.com/leaderdots.htm" rel="ugc">TelephonePhoneBook.zip</a>
</div>


<div>
A simple solution is is to create a group header on the first character for the name.<br />
<br />
Group on:<br />
Left(MyNameField],1)<br />
<br />
Sort By: MyNameField<br />
<br />
In the group header place a text box with the &nbsp;control source of: =Left(MyNameField],1)<br />
<br />

</div>


<div>
Curious, Why a B? &nbsp;What would have been better?<br />
<br />
Boyd Trimmell aka HiTechCoach ( <a href="http://www.hitechcoach.com" rel="ugc">http://www.hitechcoach.com</a>&nbsp;)<br />
Microsoft MVP - Access<br />

</div>


<div>
<div class="content wysiwyg-content">
How can I alphabetize records in a database based on the first letter of a name, and create the letter as the header
</div>
</div>


How can I alphabetize records in a database based on the first letter of a name, and create the letter as the header

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.