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

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

Guest

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
 
Hi
In your report you need to use something like
[Title]&", "&[FirstName]&","&[Surname]
 
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
Click to expand...
Click to expand...
 
Back
Top