Dlookup Question - Adding Max Lookup 1

[FontanaS]

I have the following code in a text field on the report

=DLookUp("[DataIssued]","AmendmentA","[AACETaskID] = " & [TaskID])

It works fine. I would like to get the earliest date and not the first one found.

I tried to add MIN but I got errors -
=DLookUp("Min[DataIssued]","AmendmentA","[AACETaskID] = " & [TaskID])

THANKS!

 

[jrbarnett]

=DMin("[DataIssued]","AmendmentA","[AACETaskID] = " & [TaskID])

to pick up the minimum date, DMax for the last, DCount for number of records etc. These domain aggregate functions are very useful.

John