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