I have a summary field that keeps a total of another field ... I need it to give me the summary of all records in the database not just the current found set ...

any ideas?

Define a calculated field that always is always 1.

Then make a relation with this calculated field on the left and right side.

Then define another calculated field with calculation:

Sum(Relation::FieldToSummarise)

This should do the trick.

Regards,

Ernst.

ernst said:

Then make a relation with this calculated field on the left and right side.

What does he mean by left and right side???

Andrew,

In the Define Relationships dialog, when you are creating a new relationship, you will be presented with two columns which list fields. A list of fields in the current file is displayed on the left, while a list of fields in the file that you are creating a relationship is displayed on the right. You must then select one field in each column as the match fields on which the relationship will be based.

Ernst is suggesting that you select the same field (ie the calculation field he is proposing) in both columns.

I thought a bit more about this and found that it's better to have the relation between a global number on the left side of the relation and the calculated field on the right side.

Advantage is that the sum of all records then still displays when there are no records found.

See attached sample.

Regards,

Ernst.

summary.fp5.zip