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

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


"Mandy J.S." wrote:

> 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

That worked fabulously.  Thank you!!!!

Mandy Jo

"Ofer Cohen" wrote:

> 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
> 
> 
> "Mandy J.S." wrote:
> 
> > 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