Dmin for nearest date

[Dan @BCBS]

DMin ( expression, domain, [criteria] )



A column in my query calculates a due date for each record.
The report needs to show the nearest/soonest due date for each employee.

The report is sorted by employee so I figured I could put this into a text
box:
=DMin("DueDate","q_Inventory","DueDate")

But, under every employee is the same date, it shows the minimum date in the
query, but not for each person...

How can I make it reflext each Min date?

???

 

[KARL DEWEY]

Try a Totals query and change DueDate from Group By to Min.