I would like to run an update query on a table that contains two fields. One field contains either
a last name or descriptors of multiple words. I would like to delete all last names, i.e. all cells in
the field that contain only one word. What would be the simplest way to achieve this update?
I primarily need to know what would go in the criteria field to null the "last name" cells.