Find First Date in Recordset

[denright]

I have a Report that is based on a Query. I want one field on the Report to show the earliest date in the recordset. I am having a total blank on the best way to achieve this. I'd appreciate any help on this. Thanks!

 

[PaulBricker]

You should be able to add a field to your report.

=DFirst("DateFieldName","TableName","PrimaryKeyFieldInTable = '" & [KeyFieldinReport] & "'"

This syntax is for a text datatype Key field. If it's numeric, get rid of the single quote ' marks.

Paul