agaperrk Posted April 2, 2011 Posted April 2, 2011 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..
Vaughan Posted April 3, 2011 Posted April 3, 2011 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 ) ; "¶" ; ", " )
agaperrk Posted April 3, 2011 Author Posted April 3, 2011 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.
Recommended Posts
This topic is 5252 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now