You could use an Analysis Field. You would have to amend the layout to have an expression that printed the correct text for the value in the Analysis Field

e.g. ANALYSIS1 = HSBC then print HSBC account details else print Lloyds account details

so you can create a expression that is analysis 1 says Nat west I will pull the details for the Nat west account and then if Analysis 1 says RBS it will pull the RBS bank details ?

this is something that we are looking at 

I think Ken means you would have to hard code the bank details into the expressions for each one. There is a bank file but you'd have to join to it using the bank id stored in Analysis1 rather than an ID like HSBC or Lloyds .

Actually I was thinking of just entering the text for each bank account.

A second option would be to use the actual details from the bank table and join the bank table into the report so Analysis 1 is either 1200 or 1210 etc for each live bank account

Perhaps the simplest method is to have multiple textboxes stacked on top of each other. Then use the filter property so that only one box actually prints

How would i be able to do this, i have only used the basic data fields and don't know how to link tables. 

Have a look at these screenshots and see if you can work out what I've done.

Last image wont load which is a shame

If you really can't work this out then best share your layout and I'll have a go at amending it.