I have an Access Database with a table in it containing "Full Name". This full name could be either a first and last name of an individual or it could be a business name. Is there an access query or module that I can use to determine from the name if they are a business or an individual by the number of spaces or anything like that?
Idealy I would like First, last, business, title, etc.. all split out. and field for BUS or HOM customers. But I am working with some unclean data and need to clean it, so to speak. Once it's clean I will be adding the marker, as you say.
I thought there was an access module or something like that which would go through each line and tell you if it has more than one space then it's a business, etc. I know it probably wouldn't cover 100% but I need at least 90%.