Qrew LegendIs it a Date field from the first child created that you want to summarize up to the Parent?
If so you can go to the Relationship and make a summary Minimum of the [Record ID#]. The look that up down to the children.
Then make a new summary field of the Minimum of the Date field subject to the filter that the [Record ID#] = [Minimum Record ID# (summary field lookup)]
Hi Mark, Thanks for the reply. Yes, the field I want to summarize up to the parent is a Date field. I created summary "Minimum Record ID#" using [Record ID#] as seen below.
The Minimum Record ID# field ha the following attributes:
I did not understand the last part: "Then make a new summary field of the Minimum of the Date field subject to the filter that the [Record ID#] = [Minimum Record ID# (summary field lookup)]".
Am I doing this in the same relationship as the above? So, another summary field created in the same location as "Minimum Record ID#" but setup the following way:
Summary
Minimum for the field: [EFP Date]
How do I do the: [Record ID#] = [Minimum Record ID# (summary field lookup)]"? Is this in the Child Table?
