Combining Data from 2 columns into into 1

[Judd123]

Hi,
I have got data in an excel spreadsheet and i have imported it into a table i have in my database. The data i have imported has peoples "First Name" and "Surname". So they are both in my database in 2 separate columns, however i need them to combine into one column "Cadet Name" e.g., Judd, Chris. I am not sure weather it can be done by building an event or if i have to make a query.
Any help anyone can give me would be greatly appreciated
Thanks,
Chris

 

[Rabbie]

You can do it with an update query which populates a field FullName using Surname & ", " & FirstName. The question is why bother because you can always use the above to calculate the full name whenever it is needed in a report or form.

 

[Judd123]

Thanks for the reply,
The reason I am doing this way is because i have already made a form and in that form i have a button that relies on "Cadet_Name" which will then open a new form with a "Cadets" details and information
Is there no way of building an even in the table that will automatically combine the 2 columns together?

 

[Rabbie]

from my first post

You can do it with an update query which populates a field FullName using Surname & ", " & FirstName.

Read up on update queries in Access help

 

[Rabbie]

Thanks for the reply,
The reason I am doing this way is because i have already made a form and in that form i have a button that relies on "Cadet_Name" which will then open a new form with a "Cadets" details and information
Is there no way of building an even in the table that will automatically combine the 2 columns together?

Just merge the two values in a new string field. Guess what? the formula in your event code will be

Me!Surname & ", " & Me!FirstName


You really should not store the same data twice in a table. Read up on data normalisation.