extracting text out of a column

[Mandy J.S.]

This table is linked to another database. I have one column that contains
data that starts out with the job number. I want to make another column in a
query that shows just the job number. It is formatted as so: "06-0207 -
update progress" and I want to have another column that contains only the
06-0207 part. Here is what I had done in Excel: LEFT(B2,FIND(" ",B2)).
However, I don't want to use Excel. Any ideas? Thanks.

Mandy Jo

 

[Ofer Cohen]

You can use the function Left with the function InStr that will find the
location of the space between the number and the description

Something like

Left([FieldName],Instr([FieldName]," ")-1)

 

[Mandy J.S.]

That worked fabulously. Thank you!!!!

Mandy Jo

You can use the function Left with the function InStr that will find the
location of the space between the number and the description

Something like

Left([FieldName],Instr([FieldName]," ")-1)


--
Good Luck
BS"D

This table is linked to another database. I have one column that contains
data that starts out with the job number. I want to make another column in a
query that shows just the job number. It is formatted as so: "06-0207 -
update progress" and I want to have another column that contains only the
06-0207 part. Here is what I had done in Excel: LEFT(B2,FIND(" ",B2)).
However, I don't want to use Excel. Any ideas? Thanks.

Mandy Jo