I have a DB that has table links from a SQL table. in a query for the employees name when I join forename & Surname e.g. [forename]&space(1)+[surname] the field is a bit out of alignment.
For example this is how it appears Roy Atherton
whereas I would like it to appear like Roy Atherton.
Can anyone help with this
thanks
For example this is how it appears Roy Atherton
whereas I would like it to appear like Roy Atherton.
Can anyone help with this
thanks