Need help with a query to a form, Please.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that has a field with multiple names...

Example
name of the field is Name
however the field name has the First Name, Last Name and Middle Initial...

I would like to have a query that will separate all and put them in a field
category by itself.

I greatly appreciate all the help.

Sincerely,
Monti
 
Monti,

This will only be possible for those records that follow a precise
pattern. For example, is your meaning that the data is presently
entered like this?...
Fred, Smith F
If not, please give some examples of the actual data.
You can do it with an Update Query. Any names that do not follow the
exact pattern, for example if there is a two-word LastName, such as De
Longhi, or a two-word First Name, such as Peggy Sue, you will need to
manually adjust afterwards.
 
Back
Top