Split Data

[wizcow]

Hi

I have a field in a table called 'Location'
The problem I have is the user has typed in data for "Location" and 'Area"

I would like to split the data.

I think I should use an Update query.
Now I need help with the criteria.

Here is a sample of the data;

PEEJAY 10-21-84-16
SUNSET b-38-J/94-H-2

The first part 'PEEJAY' and 'SUNSET' should be in the 'Area' field.
The second part '10-21-84-16' and 'b-38-J/94-H-2' should stay in the 'Location' field.

I think if the criteria trimmed the text, from the left, up to the space, that would work.
How would I go about entering criteria for that?

Thanks
Tom

 

[WayneRyan]

Tom,

The two fields are:
Mid([Location],1,InStr(1,[Location],' ') - 1)
And
Mid([Location],InStr(1,[Location],' ') + 1)

Wayne

 

[wizcow]

Perfect!

Thanks once again Wayne.

Tom