Group by variable ?

JethroUK© · Jun 10, 2006

Is it possible to group a report other than by pre-defined fields - e.g:

Group by 1st Letter of surname ( Left([surname],1)

A, B, C, etc

Duane Hookom · Jun 10, 2006

You can use most expressions in the Group By of a report such as:
=Left(Surname,1)
or
=Month([SalesDate])
or
=Len([Surname])