Jump to content

  •  

Photo

Calculation to equal Text

FM7

  • Please log in to reply
2 replies to this topic

#1 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 02 April 2011 - 09:31 AM

I have a data base that I am keeping track of speeches each event creates a new record and I have it tied to a contact ID I just want a summary field listing all the talks this person gave with a comma between them......... I do not want to do a report layout just a calculation field listing the talks a person would be giving.


Thanks in advance..
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com

#2 Vaughan  Mostly Harmless

Vaughan
  • Moderators
  • 10,294 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:8, 9, 10, 11
  • Membership:TechNet
  • Time Online: 4d 9h 48s

Posted 02 April 2011 - 06:22 PM

Use the List() function to concatenate all the related speeches into a return-delimited list. Then use the Substitute() function to replace the returns with commas and spaces. Try this code:

Substitute( List( speeches::speech_name ) ; "¶" ; ", " )
  • 0
Vaughan Bromfield
Sydney, Australia

Please post questions to the Forum, not directly to me. Back-up your files before making changes!

Whenever I hear the term "popular culture" I reach for my Iridium Q-36 Space Modulator.

#3 agaperrk  enthusiast

agaperrk
  • Members
  • 85 posts
  • FM Application:7
  • Time Online: 8h 57m 3s

Posted 03 April 2011 - 03:37 AM

Use the List() function to concatenate all the related speeches into a return-delimited list. Then use the Substitute() function to replace the returns with commas and spaces. Try this code:

Substitute( List( speeches::speech_name ) ; "¶" ; ", " )


the list function is not in 7 at least I cannot find it....... I need like a sum field.
  • 0
___________________________
Randy Koonce
email:koonce@randykoonce.com
www.randykoonce.com





FMForum Advertisers