G
Guest
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?
???
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?
???