reverse concatenate

  • Thread starter Thread starter Via_Doug
  • Start date Start date
V

Via_Doug

I have a Query that I want to take the characters to the
left of the first space and feed it in to a new column.
I have looked at putting in an expression with a built in
function. The function in Excel is "search" this is not
in Access. Does anyone have a way to do this.
 
Access 2000 and later has a Split() function.
In earlier versions, use Instr().
Left() and Len() may also be useful.
 
Back
Top