slecting subform data

[chrisl]

Hello,

I am working on a report that prints from a form. This form has a subform with many records that relate to it's parent.

The only information that we are interested in on the report is the last record on the subform, aka the greatest numerical key from the subform that relates to the parent
key (if that doesn't make sense please let me know and I'll explain it with a little more detail).

Is there a way to reference this record via a text box on the report?

Thank you in advance for any help.
christine

 

[David R]

You may need a few levels of queries, but look at using the Max option of a grouped query to get that data. If you include the primary key from your main table you should be able to get the max subform record for each main form record.