E
Eagle One
2007
Is there an Access function to update field2 with a subset of the contents of field1?
Specifically, I know that I can use a Mid() function but how can I code an SQL statement to:
CurrentDb.Execute "UPDATE COA_EOY Set field2 = Mid([field1],1, ????? position of ":" ?????)
In other words, is there an available function to Find or Search the position number of ":" in the
contents of field1.
If not, is there an alternate approach?
TIA EagleOne
Is there an Access function to update field2 with a subset of the contents of field1?
Specifically, I know that I can use a Mid() function but how can I code an SQL statement to:
CurrentDb.Execute "UPDATE COA_EOY Set field2 = Mid([field1],1, ????? position of ":" ?????)
In other words, is there an available function to Find or Search the position number of ":" in the
contents of field1.
If not, is there an alternate approach?
TIA EagleOne