Creating a Special Group 2

[smil3y]

Using crystal with VB I am able to create groups and have even managed to perform some formatting on the group using formula.
I have a query that provides several data fields including 'Lastname' the lastnames are sorted in ascending order. I can group by 'Lastname' but what I would like to do is group alphabetically. Can anyone assist me with creating a group ie A, b, c etc so I can list all lastnames under groups alphabetically.

Appreciate any help.

 

[e11a]

Create a formula to show left(lastname, 1) and group on that.

HTH,

Ella

 

[smil3y]

I tried something like that but ended up with multiple groups ie there are many lastnames starting with A, B C etc so I end up with a group A before every lastname starting with A.

 

[nagornyi]

Do not select that formula among the fields to display, just group by the formula. Menu: Insert--? Group--> Pick your formula from the drop-down list.
For the formula you can use also
{lastname}[1]