Recent content by arpgis

Thanks Moniker, I thought the Split Function was only in access 2007? I only have access 2003 (should have made that clear) Is there a way of splitting the field using queries?

Hi I'm having a senior moment... I have a reference field - examples below and need to split into the component parts example Ref_IDs: C21/0051,Sheet 18, Sheet 19, E 3, 12/01/07 C21/0052.04, Sheet21 ,E 2 C21/0054, Sheet 23, B 2, 05/01/07 First - ref no, Second - Sheet (note some have more...