Split Text field inot multiplie fields - problems with functions

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

--
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parse a field into 2 fields 4
Splitting Names Problem 3
Replace blank fields with 0 1
string delimiters not recognized 2
Ghost Aen fields from replication now causing problems 2
How to replace all instances of a text string with a field referen 2
VBA Functions and Modules don't work in queries 6
Outlook 2002 and problems with calendar 3

Top