Can I create a string from a single field of several records?

J

Jett

I have a combo box for selecting multiple names in my form, but when I make
the report i want it to show up as a comma delimited string (name 1, name 2,
name3...)
thanks
 
G

Guest

Hi
In your report you need to use something like
[Title]&", "&[FirstName]&","&[Surname]
 
J

Jett

The entries are not seperate fields of the same record. They are the same
field in different records. (record1[name], record2[name], record3[name])

Andy B said:
Hi
In your report you need to use something like
[Title]&", "&[FirstName]&","&[Surname]

--
Andy.


Jett said:
I have a combo box for selecting multiple names in my form, but when I make
the report i want it to show up as a comma delimited string (name 1, name
2,
name3...)
thanks
 
Top