Extract Specific Data

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi Groupies

The data in my Job Number field looks like this:
DC-2010-1-63 - City Hazard
AB-2010-5-960 - Shop

How can I extract everything up to the 4th dash so that I am left with:
DC-2010-1-63
AB-2010-5-960

Thanks in advance.
 
Assuming that the first space always occurs just before the 4th dash,
something like this in a query with the proper field name:

TheJN: Left([Job Number],Instr([Job Number], " ")-1)
 
Back
Top