Grouping Multiple fields (Firstname/Surname) (1 Viewer)

[kacey8]

Howdy Folks.

Hopefully an easy one.

I have a report with the fields

Firstname_
Surname_
[field1]
[field2]
etc etc (they're not called field1/2 but they're irreverent at present.

On the database people can be entered multiple times so I may have


Bob Smith
Jimmy Carter
Bob Smith
Jackson Smith
Tim Jones
Jackson Smith
Bob Holmes


Now I now with the group function I could group by the firstname_ field but the results would group like the following

Bob Smith
Bob Smith
Bob Holmes

Jackson Smith
Jackson Smith

Jimmy Carter

Tim Jones

And if I do it by surname, well I am sure you get the drift.

So how can I sort so I would get the following

Bob Smith
Bob Smith

Bob Holmes

etc etc.....


I hope this makes sense.

 

[pbaldy]

You can put a concatenated field in the report's source query and group on that, or group on an expression concatenating them.

 

[CJ_London]

or use SELECT DISTINCT rather than grouping