Display records based on specific values

[Ixtreme]

I have a subform that displays transactions. Each transaction has at
least 4 parties: an originator (ORIG), a originator bank (SEND), a
beneficiary (BENE) and a beneficiary bank (RECV). I would like to have
each transaction being displayed just like the money flows: ORIG->SEND-

RECV->BENE

What do I have to to have the transactions sorted based on this party
field?

 

[Ken Snell]

Add a calculated field to the query that provides the data for the subform:

SortField:
Switch(NameOfPartyField='ORIG',1,NameOfPartyField='SEND',2,NameOfPartyField='BENE',3,NameOfPartyField='RECV',4)

Now sort ascending on this new calculated field.

 

[Ixtreme]

Thanks Ken! That did the trick.

Kind regards,

Mark