Two Fields into One

[Tim]

I have one table which contains two fields first name and
surname. I would like to produce a second table which
displays both these names in the same field, surname
first. How can this be done with out retyping the list of
names?

 

[JSand42737]

I have one table which contains two fields first name and
surname. I would like to produce a second table which
displays both these names in the same field, surname
first. How can this be done with out retyping the list of
names?

Tim

Firstly, I would advise against storing a combined name in the database, as it
can very easily be obtained from a select query whenever required, and I find
it easier to have the forename and surname always in separate fields, as it
helps with querying and is more flexible.

If you wish to create a select query to view the information, then create a new
query, and add the table. Click in the first column in the query grid, and then
type in the field cell:

FullName: [FirstName] & " " & [LastName]

Where FirstName is the name of the forename field in the table, and LastName is
the name of the surname field in the table. When you run the query, you will
see the data as required.

If you do want to have a separate table, then use the query that you have just
created, and change its type to a Make Table query, and enter tha name of the
output table when asked.

 

[MRDDRD]

Write a query with a field to combine the names

combinedname: ([firstname] & " " & [lastname])

note: &" "& will put a space between the names


Then use the Make Table Query function to put the combined names into a new
table