N00B here,
I have a field GIVEN_NAMES with first name and middle name separated by a space. Some entries have only the first name.
So, running this query
FirstName = Left([GIVEN_NAMES]), " ")
doesn't work, as it leaves the output blank when it cannot find the separating space.
Any ideas how to separate these?
In addition, if I run this as an update query, it doesn't work, but also places a "0" in the GIVEN_NAMES field. Lucky I backed up my table!
Cheers,