Combining fields in query

  • Thread starter Thread starter Sharon Williams
  • Start date Start date
S

Sharon Williams

Guest
I know this can be done, but I'm stumped. I have three name fields in query that are lookups to a people field in the table. I want to concatenate (is that the right word?) the fields to one for a report. I want the names to look like "John Smith/Jane Doe/Jane Smith) Any of these fields may be null. What I get when I join the fields is ID #s instead of names, like "123/456/789" . The names come up right in their respective columns but the new field is changed to ID. Can anyone help? Sharon
 
Create a query with your table that has the ID's of individuals and also your lookup table that has the actual names. I assume that a relationship already exists between these to tables so this relationship will be added by Access when you add the two tables to the query. Drag the fields that you need to the grid form the first table. Add a column with something like this in the 'Field:' row -

Names: 1stName & "/" & 2ndName & "/" & 3rdName

Replace 1stName,2ndName and 3rd name with the actual field names of your lookup table that contain the names.
 

Users who are viewing this thread

Back
Top Bottom