Data from two fields into one in a selectquery

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

Guest

Hi

I have a select query as record source for a form.
In this query I have two text fields "Firstname" and "lastname".
I would like to create an unbound field in the query and ad the data from
the two fields in to this new field.

Is there any easy way to do it?

Thank you in advance!

Mattias
 
Hello there,

If I have this right you want the Full Name to appear in
another field. If this is the case you need a calculated
field:

1. Create the query.
2. In the next available column:

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

FullName - The name of the new field
: - Seperates the Name from the Calculation
" " - Adds a space between the first and last names

Hope this helps

Judith
 
You can use a Calculated Field in the Query like:

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

(type the above in the "Fields" row of aqn empty Column in the Query Grid)
 
Back
Top