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.