Split Text field inot multiplie fields - problems with functions

  • Thread starter Thread starter Richard Black
  • Start date Start date
R

Richard Black

Hi,

I have some data in the format "NURU67-72 (M03) Grp10". I want to split it
into 3 fields, using spaces as delimiters, but am having problems. I have
tried the split() funtion, but Access 2002 reports that this is an undefined
function. I have tried to use the InStr() and InStrRev() functions, but I
just get "#error"

Anyone got any suggestions? Am I missing some references or DLLs?

TIA,

Richard Black

--
 
Instr(), Mid(), and Left() should be able to provide the functionality that
you need. What expression(s) did you try?
 
Back
Top