I have a database of end-of-term school reports that the staff have completed a new record for each child.
In the general comments field, some of them have left a space in, and some have a full stop and a space before the text starts.
Is there a way of saying, in this column/field, search through and if the 1st character is a fullstop or a space then remove it??
The files are in access.
Any help would be great.