referencing text box within report

[Alessia D]

I have the report set up something like this

Runtime Date
0 01/042006
2 02/05/2007

I have the formula to find the minimum and max runtimes at the end of the
page, but what formula can I use to reference the date associated with that
runtime?

 

[ghetto_banjo]

Is the Run time always unique?


If so you could use a DLookup formula. Something like:


=Dlookup("[DateFieldName]", "table/query Name", "[Runtime] = " & Max
([RunTime]) )

 

[ghetto_banjo]

if your Runtime is always unique, then you could use a DLookup
function:

=Dlookup("[DateFieldName", "Table / Query Name", "[Runtime] = " & Max
([Runtime]))