Display records based on specific values

  • Thread starter Thread starter Ixtreme
  • Start date Start date
I

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
Click to expand...

What do I have to to have the transactions sorted based on this party
field?
 
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.
 
Back
Top