Group by variable ?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

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
 
You can use most expressions in the Group By of a report such as:
=Left(Surname,1)
or
=Month([SalesDate])
or
=Len([Surname])
 
Back
Top