Hi,
I wonder if anyone can tell me how to do the following.
Company Address Group
ABC Ltd 1 Main Street Sales
DEF Ltd 2 Smith Street Accounts
GHI Ltd 5 Jones Street Accounts
JKL Ltd 7 Green Street Purchase
I would like to get displayed like
ABC ltd Sales DEF Ltd. Accounts
JKL Ltd Purchases GHI Ltd Accounts
What I get is....
ABC Ltd Sales
DEF Ltd Accounts
GHI Ltd Accounts
JKL Ltd Purchases
I tried putting the fields as formula but still get the same results. Any ideas, I must be doing wrong.
Edited by directred - 26 Apr 2011 at 8:28am