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?

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.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Ixtreme" <(E-Mail Removed)> wrote in message
news:4244c8cc-77bd-4877-bce7-(E-Mail Removed)...
>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?

Thanks Ken! That did the trick.

Kind regards,

Mark