Thanks Lowell your example works,
I also note the warning provided by SteveB. I understand this and I am hoping this is just temporary until the company that support us can actually change the database structure.
Cheers Guys for your speedy response.