Recent content by bigboab5

Thanks guys, worked a treat, worked best wi the Trim function best. I was at this for ages, so again thanks for your speedy replies. Boab

Hi guys, Wonder if any of you can help me. I have an access database (2007), its very simple, only 2 fields. The problem is I want to split one of the fields into 2 separate fields. The field is a text field which is always in this format: [xxxxx] yyyyyyyyy (sample: [Displ] Cold-Pheonix )...