Search results

Sorry I was. The joys of cut and paste! I've substituted the full stop with a space and it works! Thanks for your help.

Thanks Paul. I looked up InStr on Access help (I'm not a programmer) and tried to use an example they had in a query by substituting field names as follows Expr1:Left([forenames],(InStr(1,[forenames],"."))-1) The query returned an error. Any thoughts on what I'm doing wrong?

Hi, Has anyone got a suggestion as to how I can run an update query which populates a new field with the the text to the left of the first space in a string? I'm trying to create a first name field from data where the first and middle name are in the same field. Thanks GEOFF