Help to return results in a certain order

[froggy]

Hi,

i would like to return information in the below format but not very sure how it is to be done.

Role, Name, ID, Contact Number
Z, Mary, 05, 1234567
, Matt, 02, 2233445
A, Bob, 10, 7654321
C, Tammy, 11, 9988776

and the order of Role (Z,A,C) is fixed it has to be in this order and if Role Z has more than one person, it will return only the name, id and contact number but will not repeat the role.

 

[gemma-the-husky]

your query will HAVE to repeat the role code - when you use this in a form or a report, you have more control over the exact layout formatting.

Obtainnig an unusual sort order cannot be achieved directly. you would have to store another column of data to determine the sort order within your roles