getting part of data to populate new field

E

EMD

I a field named SIZE (text) , value examples are: 3 x 2-1/2, 1/2 x 2, 1-1/2 x
2-1/4.

now I want to get the first size before 'x' to write it to new field SIZE1
and the second size after the 'x' to SIZE2 field.

Can I do this using an update query.

thanks in advance
 
G

Gerald Stanley

Try something along the lines of
UPDATE YourTable SET size1 = Left([size],InStr([size],'x')-2), size2 =
Mid([size],(InStr([size],'x')+2));

The above assumes that there is a space either side of the x

Hope This Helps
Gerald Stanley MCSD
 
E

EMD

Hi,

thanks so much, it solve my problem.


Gerald Stanley said:
Try something along the lines of
UPDATE YourTable SET size1 = Left([size],InStr([size],'x')-2), size2 =
Mid([size],(InStr([size],'x')+2));

The above assumes that there is a space either side of the x

Hope This Helps
Gerald Stanley MCSD

EMD said:
I a field named SIZE (text) , value examples are: 3 x 2-1/2, 1/2 x 2, 1-1/2 x
2-1/4.

now I want to get the first size before 'x' to write it to new field SIZE1
and the second size after the 'x' to SIZE2 field.

Can I do this using an update query.

thanks in advance
Click to expand...
Click to expand...
 
Top