Hi i am trying to make an update query that will put peoples "first_name" and "surname" (in teh same table but seperate columns) into one column to give me "first_name,"surname" as one. I have been told to use an update query but i cant make sense of all the help on the internetAnyone with any ideas would be helpfulThanks
Update Query
- Thread starter Judd123
- Start date
maxmangion
AWF VIP
- Local time
- Today, 11:01
- Joined
- Feb 26, 2003
- Messages
- 2,805
You shouldn't be doing that to store this "calculated field" in your table. You do not even need to use an update query.
In your query simply put FullName: [first_name] & " " & [last_name] in an empty column while in design view.
In your query simply put FullName: [first_name] & " " & [last_name] in an empty column while in design view.
