Sorting multiple fields as one in report

P

PizzaBoy

Hello Group,

I have a report based on a table in which each record contains a unique ID
number and fields for up to three owners in each record. I would like to
have a report which lists all three owners as if each was an individual was
a unique record instead of three per record. I then want to sort the report
based on last name. Currently if I sort the report I can only sort by one of
the three name fields. Any help is greatly appreciated. Thank you.
 
Top