Display Latest Record in the Cross Tab Summary

This can be accomplished through a summary field, then passing that summary as a lookup, then using that lookup as a condition for your summary.  Sounds confusing, but it really just 3 steps.

Step 1:  Create a summery field to summarize the "Maximum" Record ID# from your child table.  Might create a field called [Maximum Record ID#]

Step 2:  Pass that new summary field [Max Record ID#] as a lookup field back to the child table.  it might call the field something like [Quote - Maximum Record ID#]

Step 3:  Create another Summary field of your dollar value, but make sure you place this condition;  "Only summarize values when [Record ID#] is equal to the value in the field [Quote - Maximum Record ID#]

let me know if you get stuck.

Hi Matthew, your explanation is very clear.

I'd like to achieve the same thing but I can't rely on the record ID# as the identifier for the latest record, instead I need to reference a date field. I need QB to determine which is the maximum child record based on the date in the date field and return the record ID# of that record with the most recent date. I have managed to create a summary field that returns the date of the record that has the latest date but am as yet unable to translate that in to a record ID#.

The reason for this is that we are back-filling data so we can't rely on the highest record ID# being the most recent value.

Kipp,
no problem,
1. Summary of the maximum date.  Call it [Most Recent Date]
2. Lookup up down to detail records.
3. Summary of Maximum Record ID subject to the extra condition that the [Record ID#] equals the value in the field [Most Recent Date].