Getting the first value in a recordset

[John]

Hi

I am grouping on a number of fields in a select query. How can I get the min
value of a date field in the overall query result set? If I choose
min([date]) then I get the min dates in each of the group and not overall
min value.

Thanks

Regards

 

[Van T. Dinh]

Try using DMin() as a Calculated Field / Column in your Query. Check Access
Help for syntax.

BTW, "date" is a bad choice for a Field name. There is a Date() function as
well as a Date statement. It can get very confusing when you write code.
Suggest changing the Field name if possible.

HTH
Van T. Dinh
MVP (Access)