"Keith Wilby" <he**@there.comwrote in message
news:48**********@glkas0286.greenlnk.net...
How do you find the earliest of a set of dates in a field using a query?
I thought using "min" in a totals query would work but it seems to treat
the date like text. I feel a forehead slapping moment approaching ...
TIA - Keith.
Well, if the field/column you are using is formatted as a string and not as
a date, then try changing your "min" expression from:
[fieldname]
to:
cdate([fieldname])
or:
format([fieldname], "mm/dd/yyyy")
Fred Zuckerman