How to create a Combined Text summary field using a relationship field

Question

I need to display the field value for each child record of the parent table in a report in a Combined Text summary relationship field. I'm getting this error when trying to create the combined text summary field:
"That summary function cannot be applied to this field..."
The field I need to create a summary of is being pulled from yet another child table&nbsp; (SEO Bucket Rate Card) (grandchild) related to the 1st child table (SEO Deliverables) of the parent table (SEO Deliverable Cycle)

Table Name / Relationship
`SEO Deliverable Cycles` = Parent
`SEO Deliverables` = Child
`SEO Bucket Rate Card` = Grandchild

I'm stumped - any way around this?------------------------------Matt Makris------------------------------

markshnier__you · Answer

A Combined text summary will only summarize a text field type.

If your field is numeric then you will need to make a formula field to convert it to text. Then summarize that text field.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

chayceduncan · Answer

You can also use a formula query as it is indifferent to field type as compared to your more traditional summary fields.&nbsp;------------------------------Chayce Duncan------------------------------

markshnier__you · Answer

...&nbsp; but Formula Queries have more possibility of impacting performance.&nbsp; &nbsp; :)------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

How to create a Combined Text summary field using a relationship field