Comma

[tmcrouse]

I feel like an idiot. I cannot remember how to do an update query on a name without a comma. I have 1 field that is Last First but with no comma and want a comma.

FAM
Jones Angela

I want Jones, Angela

I forgot how to do this.

[boblarson]

AliasNameHere:Left([FAM],Instr(1, [FAM], " ") -1) & ", " & Mid([FAM], Instr(1, [FAM], " ") + 1)

[tmcrouse]

Thanks it is giving me a syntax error though

[boblarson]

I just tested and it works as a new field (with an alias), but if you are trying to use it as the UPDATE part of an update query then you would need to remove the alias part and just use:

Left([FAM],Instr(1, [FAM], " ") -1) & ", " & Mid([FAM], Instr(1, [FAM], " ") + 1)

[tmcrouse]

Great. It was the alias thing that threw it. It works just as an update. Thanks so very much.