Update Single Field from Multiple Fields

[bobbye_69]

:banghead:
I wrote a database several years ago and recently pulled it out to give to a friend. The problem is, back then (not knowing better) I set the Employee table up with as a single field "NAME". Now, in order to make it effective, I need the Employee's name in four (4) parts (First, Middle, Last, Suffix).
I have several queries based on the "NAME" field and and would like to avoid changing all of them. I have a simple form "frmUpdateEmployees" that populates the Employee table and Name field. I was hoping to change the form and/or add a query that would be easier and more simple.

Table: Employee
Field: Name
Form: frmUpdateEmployees
Queries: 16 that depend on the table and field above.

Thanks in advance for your assistance.

 

[MarkK]

You've presented conflicting problems:

• need to split up name field,
• don't want to rewrite queries that depend on name field.

And you haven't asked a question. What kind of assistance are you seeking?
I recommend you split up the name field and rewrite the queries.

 

[Mihail]

If the table Employe has, as primary key, a n autonumber AND if the queries use this autonumber is not necessary (I think) to modify the queries.
Show us the structure of your table or, better, post the table with some data.

 

[bobbye_69]

Thanks for your replies. I am going to rewrite the queries and split the fields. After thinking about it and reading Mark's reply, I have come to the conclusion to fix it now and not Band-Aid it. This way, as I grow it (having more knowledge now) I can do it the right way.

Thanks for your assistance.

 

[MarkK]

This, IMO, is always your best policy.

fix it now and not Band-Aid it.

 

[Mihail]

Fully agree !!!