referencing text box within report

  • Thread starter Thread starter Alessia D
  • Start date Start date
A

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?
 
Is the Run time always unique?


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


=Dlookup("[DateFieldName]", "table/query Name", "[Runtime] = " & Max
([RunTime]) )
 
if your Runtime is always unique, then you could use a DLookup
function:

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