Using Group By For More Than One Group 1

[Bluejay07]

Hello,

I am working on a report in which I am setting the group by section based on an ID field. I would like to know if it's possible to use the group by function to group several similar groups together?

Here is an example of the various ID fields:
ABC
ABC1
ABC2
ABC3
XYZ
XYZ1
XYZ2
XYZ3

Instead of having 8 separate sections, I would like to group the similar groups together, therefore I would only end up with 2 groups: ABC and XYZ.

ABC would contain ABC, ABC1, ABC2, etc.
XYZ would contain XYZ, XYZ1, XYZ2, etc.

Any advice would be appreciated.
Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[fisheromacse]

you could create a formula and then group on that formula.

//{@First3}
LEFT({YourTable.YourField},3)

 

[Bluejay07]

Thank you.
I will give that a try.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[Bluejay07]

Thank you. Your response seems to be exactly what I was looking for.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[fisheromacse]

These forums have been a great help to me.

I am happy to have been able to help you!