Hi Folks I'm very much a beginner, using Access for small hobby projects at home. I suspect I rarely use the most efficient way to do things, but they work.
My question today is about names. At various points in my small family history project, I want to see names formatted as
Surname, First & Middle names
or First name Middle names Surname
My base data currently consists of 3 separate fields, First name, Middle Names & Surname.
Is it better to created a calculated field in my table or use a query to generate the merged versions, or is there a far more sensible approach.
Thanks
My question today is about names. At various points in my small family history project, I want to see names formatted as
Surname, First & Middle names
or First name Middle names Surname
My base data currently consists of 3 separate fields, First name, Middle Names & Surname.
Is it better to created a calculated field in my table or use a query to generate the merged versions, or is there a far more sensible approach.
Thanks