On Sat, 16 Oct 2004 03:33:42 +0100, "John" <Jo**@nospam.infovis.co.uk>
wrote:
Btw, "Date" is a reserved word. Rename your field to something like
"PaymentDate", "OrderDate", etc.
If I understand you correctly, you currently have:
select min([Date]) from MyTable group by SomeField, SomeOtherField
If you want the absolute minimum, just remove the Group By:
select min([Date]) from MyTable
-Tom.
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